Join
Intersection Rows
Keeps only the rows both tables have, each once, the way SQL INTERSECT does.
When to use it
Use it to find the overlap between two lists — customers who bought in both quarters, staff on both rosters.
In a pipeline
File InputIntersection RowsExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Compare Using | select | — | Every column both tables have |
| Ignore upper and lower case | checkbox | — | false |
Example
Customers who bought in both quarters
- Compare Using=Customer
| Pin | Customer |
|---|---|
| A | Acme |
| A | Harbour |
| A | Northwind |
| B | Harbour |
| B | Acme |
| Customer |
|---|
| Acme |
| Harbour |
The rows come from table A, with A's columns, in A's order.
Worth knowing
- Table A feeds the left pin and table B the right; for this node the order changes only which table's columns and row order you get back.
- Compare Using decides what counts as the same row. Left empty, every column the two tables share is compared — and the node says which those are.
- An empty table on either pin gives an empty result, as SQL does.