Define Sets dialog

Defines the type of Set operations performed on two or more data sets.

Applies to the Set operator ( Set Operations (DB), Set Operations (HD), and Set Operations (TDV) data sources).

Setting Description
Alias Name of the new merged output column in the Alias field.
Type Type of set operation. The options are as follows.

  • UNION: Combines the results of two or more queries into a single result set that includes all distinct rows that belong to all queries in the union. Duplicate rows are eliminated.
  • UNION ALL: Combines the results of two or more queries into a single result set that includes all rows that belong to all queries in the union. Duplicate rows are included.
  • INTERSECT: Returns all rows that are returned by both the query on the left side and the right side of the INTERSECT operand.
  • EXCEPT: Returns all distinct values from the result of the left query that are not found in the result of the right query.

Select Columns Columns from each input table to include on the output table. A column is displayed for each connected input data source.
Map Columns Choose an option to automatically map the input data sets based on column name or order in the data sets. Using this option overwrites the current configuration.
  • By the order in which they appear: For example, the first column from each data set, the second column from each data set... up to the number of columns in the smallest data set.
  • By name when appearing in all datasets: Creates output columns by matching a column name from every data set. This operation is case insensitive.
  • By name when appearing in more than one dataset: Applies only to workflows with more than two input data sets. Create output columns by matching column names when that name occurs in two or more of the input data sets. This operation is case insensitive.

When the Set operator combines two or more data sets based on DateTime columns, the more precise DateTime format is used and the output is converted into that one format.