Union

The Union transformation is used to merge data from multiple datasets into one dataset. It merges data from multiple sources similar to the UNION ALL SQL statement to combine the results from two or more SQL datasets. The input sources must have a similar columns and data types. This transformation only merges the datasets and does not remove duplicates.