You can join together datasets based on the presence of one or more keys in both datasets.
- A join is a data operation in which two or more tables or datasets are merged into one based on the presence of matching values in one or more key columns that you specify.
- In , the joined-in dataset is unmodified by the operation.
- There are multiple types of joins, which generate very different results. For more information, see Join Types.
- In the Transformer page, open the recipe panel. See Recipe Panel.
- In the Search panel, enter
- Joins are specified through a wizard. For more information, see Join Window.
NOTE: If you modify the selected dataset to join, the joined dataset, the join keys, or the fields to include in the output, subsequent steps in your transform recipe can be broken by the change. After you modify the join, you should select the last step in your recipe to validate all steps in the recipe.