Articles on: Workflows

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

Was this article helpful?

Share your feedback

Cancel

Thank you!