Column
Union Columns
Puts both tables' columns side by side, keeping a column that appears in both only once.
When to use it
Use it to widen a table with another table's columns when the two overlap — last year's and this year's exports, say — without ending up with two copies of the shared ones.
In a pipeline
File InputUnion ColumnsExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Match names ignoring case | checkbox | — | false |
Example
Details beside totals, Id kept once
| Pin | Columns |
|---|---|
| A | Id, Name |
| B | Id, Spend |
| Id | Name | Spend |
|---|---|---|
| 1 | Ada | 120 |
| 2 | Ben | 80 |
Rows line up by position: row 1 of A beside row 1 of B.
Worth knowing
- A column both tables have keeps table A's values; table B's copy is dropped, and the node names the columns that happened to.
- Tables of different lengths are fine: the shorter one leaves blanks, and the node says so.
- Merge Tables does the same side-by-side work for any number of tables and can keep both copies of a repeated name, numbered or prefixed.