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 and in_right, as required.
Use leftKey and rightKey values to govern how the data records are paired up across the data input flows:
1. In Left key, add the column that contains key values (primary keys) of the in_left input flow.
2. 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 the rightKey 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.