Intro
Sometimes you want to join DataSets together but there is no unique key column to join on. In this case, you can create a unique key column.Create a Unique Key Column
Follow these steps to create a unique key column:- Open an existing DataFlow in Magic ETL or begin creating a new DataFlow.
-
Add the
Rank and Window tile to the canvas and connect it to your Input DataSet.
- Select the Rank & Window tile.
-
In the configuration pane below the canvas, select Add Function.
-
In step 1, name the new column.
-
In step 2, expand the Select the function to apply dropdown and select Row Number.
-
Select Apply.
- In step 2, choose a column to order the functions on to determine how to apply the row numbers.
-
In step 3, choose to order your column by either ascending or descending values.
- To have a unique key value for every row of your data, leave the optional What columns make up the partition option blank.
- Complete your DataFlow and run it.
