Join Condition in ETL

Options
Ganesh_Naren
Ganesh_Naren Member
edited August 2023 in Magic ETL Ideas

1.For Some scenarios we will join tables based on the between dates condition with out columns mapping

Eg select a.*,b.* from Table1 a , Table2 b where Date between date1 and date2

2.For Some scenarios we will join tables without any conditions

Eg select a.*,b.* from Table1 a , Table2 b

Tagged:
2
Up
2 votes

Active · Last Updated

Comments

  • marcel_luthi
    marcel_luthi Coach
    Options

    While having the feature would be awesome, a workaround is to add a JoinKey on both tables (constant), join on that key (basically doing a Cartesian product for the tables) and then apply filters that would replicate what you'd have specified in the regular ON clause of a SQL JOIN, you can Drop the Join Key as part of the column edits in the same Join Tile, this would do exactly what you describe in case 2.

Categories