Column
Delete Column
Removes one or more columns from every row.
When to use it
Use it to drop columns you do not want downstream, such as internal notes or scratch columns added earlier in the pipeline.
In a pipeline
File InputDelete ColumnExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Columns to Delete | select | Yes | Select columns... |
Example
Drop internal columns
- Columns to Delete=Notes, Owner
| Order | Notes | Owner | Total |
|---|---|---|---|
| SO-1 | check later | Dana | 120 |
| SO-2 | — | Ravi | 340 |
| Order | Total |
|---|---|
| SO-1 | 120 |
| SO-2 | 340 |
The remaining columns keep their original order.
Worth knowing
- Tick as many columns as you like in the dropdown; search, Select all and Clear help with wide tables.
- Deleting a column the rest of the pipeline still references will make those nodes fail, so delete late rather than early.
- To keep a few columns of a wide table instead, Select Columns is quicker.