Appending datasets (UNION)

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.
  1. Select the Combine icon, and select Append.
  2. 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.
  3. 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.
  4. Select Append.
    The two datasets are combined. The combined dataset retains the column names of the target dataset.