Union processor
Appends similar records from a dataset to the end of another, with or without removing duplicates (union all).
The Union processor allows you to append records from multiple datasets in a transformation flow.
Union properties
Properties to configure to append records from multiple datasets.
Property | Configuration |
---|---|
Union all |
Enable this option to return only distinct values while appending your columns. If this option is disabled, all duplicate values will be kept in the output. |
To rename the processor, click the Edit icon that is displayed when hovering over the default name of the processor.
To edit its description, click the Edit icon that is displayed when hovering over Description.
Limitations
Fields are matched according to the ordinal order, and not using their names. For example, if there are:
-
Table t1 with fields f1, f2, f3
-
Table t2 with fields f3, f2, f1
When running union with t1 and t2 to table t3:
-
For each record from t1, its fields would be f1, f2, f3.
-
For each record from t2 its fields would be f3, f2, f1.
If you want to match the fields differently, use the Select columns processor to change column order in one of the input tables.