Merge Rows in a Data Flow
You can merge the rows of two data sources (known as a UNION command in SQL terminology).
Before you merge the rows, do the following:
- Confirm that each data set has the same number of columns.
- Check that the data types of the corresponding columns of the data sets match. For example, column 1 of data set 1 must have the same data type as column 1 of data set 2.
Use the Union Rows step in the data flow
editor.