Union stage
A Union stage is used to combine multiple datasets
with identical sets of column headers to produce a single output. Because the
headers are the same in each source file the rows can be stacked on top of each
other to produce a single unified dataset.
If there are unmatching columns in the source schemas
they will be included in the output dataset, but only the rows from the source
of the unmatched column will be populated.
To union datasets:
1.
Insert a union stage
2.
Select inputs with matching header schemas
3.
A single unioned dataset will be output
