User Community Service Desk Downloads

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

  1. From other steps, create a connection to in_left and in_right, as required.

  2. 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.

  3. 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.

  4. Specify the columns that should be present after the join.

Was this page useful?