Use the UNION operator to append two datasets.
Both tables in the union must contain an equivalent number of columns and compatible data
types. Only a dataset that is compatible with the target dataset can be
appended.
Once a dataset has been merged with another dataset, the datasets become a unit, and you
cannot separate them.
- Select the Combine
icon, and select Append.
- In the Append Data dialog, perform one of the following actions:
| Option |
Description |
| If the dataset to append is already available in the
document |
Select the dataset in the list above the right pane. |
| If the dataset to append is not open |
Select Add New Dataset, and select the data
source to acquire and append. |
If the dataset to append is compatible with the original dataset, dimension columns are
listed under Lookup Dataset on the right side of the
pane. A sample of distinct values for each selected dimension appears in the
Sample of Distinct Values column.
- To select a different source dimension for the union with the matching target dimension, select
another dimension in the list.
If the selected dimension contains a compatible data type, the dimension can
be appended. If a The union is not possible message appears in
red, the selected dimension didn't contain a compatible data type and you must
select a compatible dimension.
- Select Append.
The two datasets are combined. The combined dataset retains the column names of the
target dataset.