Transformations
Merge Tables
Puts the columns of several tables side by side in one wide table, lining rows up by position.
When to use it
Use it to stitch together tables that describe the same rows from different places — a file of names beside a file of totals — when there is no key to join on.
In a pipeline
File InputMerge TablesExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Table Order | text | — | Node names, comma separated (blank = as connected) |
| Repeated Column Names | select | — | number |
Example
Names beside their totals
- Repeated Column Names=Number them (Total_2)
| Table | Columns | Rows |
|---|---|---|
| People | Id, Name | 3 |
| Totals | Spend, Visits | 3 |
| Id | Name | Spend | Visits |
|---|---|---|---|
| 1 | Ada | 120 | 4 |
| 2 | Ben | 80 | 2 |
| 3 | Cy | 35 | 1 |
Row 1 of each table becomes row 1 of the result, and so on down.
Worth knowing
- Every connection into this node's single pin is a table, named by the feeding node's Node Name — the same names the SQL node uses.
- The properties panel lists the tables in the order they will be merged, left to right; Table Order overrides that, naming nodes in the order you want, comma separated.
- Tables of different lengths are allowed: the short ones leave blanks under their columns, and the node says so.
- Two tables bringing the same column name is handled by Repeated Column Names — number them, prefix them with the node name, or keep the first table's column.
- Rows line up by position, not by any key. To match rows on a shared value, use Join instead; to stack rows of the same shape, use Merge Rows.