Define Sets Dialog Box

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

Applies to the Set operator (for both DB and HD 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 datasets based on column name or order in the datasets. Using this option overwrites the current configuration. By the order in which they appear: For example, the first column from each dataset, the second column from each dataset... up to the number of columns in the smallest dataset. By name when appearing in all datasets: Creates output columns by matching a column name from every dataset. This operation is case insensitive. By name when appearing in more than one dataset: Applies only to workflows with more than two input datasets. Create output columns by matching column names when that name occurs in two or more of the input datasets. This operation is case insensitive. When the Set operator combines two or more datasets based on DateTime columns, the more precise DateTime format is used and the output is converted into that one format.