Join Step
Joins two separate data flows into a single data flow (vertical merge).
This step is available for standalone plans, embedded plans, and transformation catalog items. |
Configuration
-
From other steps, create a connection to
in_left
andin_right
, as required. -
Use
leftKey
andrightKey
values to govern how the data records are paired up across the data input flows:-
In Left key, add the column that contains key values (primary keys) of the
in_left
input flow. -
In Right key, add the column that contains key values (primary keys) of the
in_right
input flow.
-
-
Select the required Join type:
-
Inner join: Only data that has a key that was found in both input flows is sent to output. In other words, records are joined when the
leftKey
value matches therightKey
value. -
Outer join: All records from both input flows are sent to output (even those with a key that was not found in both flows).
-
Left join: All records from the left input flow are sent to output (even those with a key that was not found in the right flow). Records in the right data frame which lack a match in the left data flow are dropped.
-
Right join: All records from the right input flow are sent to output (even those with a key that was not found in the left flow). Records in the left data flow which lack a match in the right data flow are dropped.
-
-
Specify the columns that should be present after the join.
Was this page useful?