Merging datasets (JOIN)

Use the JOIN operator to merge two datasets.

  • The merging dataset must have a key column.
  • Only columns with the same data type can be merged.
  • The merge process combines all columns.
Columns in the second dataset are matched to a key column in the original dataset. The application proposes potential column matches and the probability of each match.
Note Once a dataset has been merged with another dataset, the datasets are a unit. You cannot remove either dataset.
  1. Select the Combine icon, and select Merge.
  2. In the Merge Data dialog, select the key column to use as the identifying column for matching.
  3. Perform one of the following actions:
    Option Description
    If the dataset to merge is already available in the document Select the dataset in the list above the right pane.
    If the dataset to merge is not open Select Add New Dataset, and select the data source to merge.
    Columns that can be matched, based on the key column in the original dataset, are listed under Lookup Dataset.
  4. Select Merge.
Columns in the second dataset are added to the original dataset.