Using components: Union Transformation

Use the Union transformation to combine records from two inputs with the same schema (same fields and data types).

Note: Union in ETL acts like Union all in SQL (will not remove duplicate rows)

Union inputs

Select 2 inputs and drag and drop the component menu button onto the union component:

Within the component you can define which input is the left input and which is the right input.


Input field mapping

Map the pairs of fields from the two inputs into a single output field. You can auto-fill the list by order of fields in the two inputs (Auto-fill by order) or by matching field names (Auto-fill by name). You can also manually pick pairs of fields from the two inputs.