Column
Minus Columns
Keeps table A's columns, without any column table B also has.
When to use it
Use it to strip a set of fields from a table by naming them in another table — dropping the columns a downstream system already holds, or removing a standard block of fields.
In a pipeline
File InputMinus ColumnsExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Match names ignoring case | checkbox | — | false |
Example
Everything except what B carries
| Pin | Columns |
|---|---|
| A | Id, Name, Region, Spend |
| B | Id, Spend |
| Name | Region |
|---|---|
| Ada | North |
| Ben | South |
Table B is only a list of names here; its rows are never read.
Worth knowing
- Only the column names of table B matter, so a single header row on that pin is enough to say what to drop.
- The rows are table A's, untouched apart from the columns removed.
- To drop a couple of columns you can name yourself, the Delete Column and Select Columns nodes are simpler.