Join
Minus Rows
Keeps the rows of table A that table B does not have, each once — SQL's MINUS (EXCEPT), or the left-hand crescent of a Venn diagram.
When to use it
Use it to find what is missing or new: invoices not yet paid, this week's records that were not in last week's, accounts on one system but not the other.
In a pipeline
File InputMinus 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
Invoices with no payment
- Compare Using=Invoice
| Pin | Invoice |
|---|---|
| A | INV-1 |
| A | INV-2 |
| A | INV-3 |
| B | INV-2 |
| Invoice |
|---|
| INV-1 |
| INV-3 |
Order matters here: A minus B is not B minus A. Swap the pins to ask the other question.
Worth knowing
- The A pin is the table you are keeping rows from; the B pin only ever removes rows.
- Compare Using decides what counts as the same row, so two tables of different shapes can still be compared on the column they share, such as an id.
- The rows come back from table A, with A's own columns, and each one once.