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.
- Select the Combine
icon, and select Merge.
- In the Merge Data dialog, select the key column to use as the
identifying column for matching.
- 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.
- Select Merge.
Columns in the second dataset are added to the original dataset.