Intersect Node

Description

Use the Intersect node to only include rows that appear in all the input nodes.

Tips

• An intersect 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 {column1}
from {data_source1}

intersect {column1}

select {column1}

from {data_source2}

↩️ Back to Workflow Settings

Updated on: 05/10/2024