Skip to main content
Documentation
Documentation
Workday User Guide
Last Updated: 2023-06-23
Reference: Join Stages

Reference: Join Stages

You can include 2 datasets (dataset pipelines) in a Join stage. You can add additional Join stages in the pipeline if you need to join multiple datasets.
Join Stage Option
Description
Join Pipeline
Select a dataset pipeline to join with the primary pipeline. If there aren't any pipelines available, select
Add Another Pipeline
 to create a pipeline by importing a dataset.
Match Rows
Select 1 or more fields from each dataset pipeline whose values should match each other. Select the fields that uniquely identify rows in each dataset pipeline. Defining the matching rows is similar to defining a primary key/foreign key relationship in relational database terms.
You can also select an optional suggestions link that displays Workday recommended join keys. The suggestions are based on the number of matching rows between fields in the example data.
Join Type
Select the join type. The join type specifies which rows from each dataset pipeline to include in the join result.
  • Inner Join
    . Workday includes rows that have matching values that exist in both pipelines. If a row from 1 pipeline doesn't match a row in the other pipeline, the row is omitted from the join result.
  • Left Outer Join
    . Workday includes all rows in the Primary pipeline and searches for a matching row in the other pipeline. If there's no matching row in the other pipeline, Workday populates each field from the other pipeline with NULL values. When the imported pipeline includes multiple matching rows, then Workday includes both rows in the join result.
  • Right Outer Join
    . Workday includes all rows in the imported dataset pipeline and searches for a matching row in the Primary pipeline. If there's no matching row in the Primary pipeline, Workday populates each field from the Primary pipeline with NULL values. When the Primary pipeline includes multiple matching rows, then Workday includes both rows in the join result.
  • Full Outer Join
    . Workday includes all rows from both pipelines. If a row from 1 pipeline doesn't match a row in the other pipeline, Workday populates each field from the nonmatching pipeline with NULL values. When there are multiple matching rows, Workday includes all rows in the join result.
Note that Workday replaces all NULL values with default values when you publish the dataset.
Select Fields
Select which fields from each pipeline to include in the join result. Any field you don't include is dropped from that stage in the pipeline and all later stages.

This content is not part of the Workday Administrator Guide.