Reference: Join Stages
You can include 2 datasets or 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 and 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.
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. |