Union Node

Description

Use the Union node to append data from multiple input nodes with the same schema.

Optionally, you can decide to do with duplicate rows. By default, they are kept, but you can remove them with the Distinct option.

Tips

Unions work best when both input nodes have the exact same set of columns (aka schema)
It is a best practice to set the Distinct option to remove duplicates

SQL Equivalent

select * from {data_source1}
UNION
select * from {data_source2}

↩️ Back to Workflow Settings

Updated on: 05/10/2024