Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next


  • 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 
    D s product
    , 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.


  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 in a special panel. For more information, see Join PanelWindow.

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.