Use the Union transformation to combine records from two inputs with the same schema (same fields and data types).
Note: Union in Integrate.io 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:
![]( "Image: https://res.cloudinary.com/hdxhd6yxt/image/upload/v1593601808/docs/etl/union_t.gif")
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.