You can join together datasets based on the presence of one or more keys in both datasets. 

 

Steps:

  1. In the Transformer page, open the recipe panel. See Recipe Panel.
  2. In the Search panel, enter join datasets
  3. 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.