Except Node

Description

Use the Except node to remove rows that exist in a second table that has the same schema.

Tips

Like the union node, an except node can have unlimited inputs, but they all need to have the same schema (i.e. column names and data types), otherwise it will return an error.

SQL Equivalent

select * from {data_source1}
EXCEPT
select * from {data_source2}

↩️ Back to Workflow Settings

Updated on: 05/10/2024