Join Multiple
Combine 2 or more inputs into one on a shared key (or record position). Every row is kept by default, null-filled where they don't match.
What it does
Combines 2 or more inputs into ONE output on a shared key (or record position). By default it's a FULL OUTER join: every row from every input survives, and where an input has no matching row its columns come back null. Turn on "Only keep rows that match across all inputs" to make it an inner join instead. Unlike the two-input Join, the shared key comes back as a SINGLE coalesced column, never null while any input supplied it.
Inputs and outputs
| Inputs | As many as you set on the node, 2 to 16. |
| Outputs | One. |
When to use it
- Stitch several keyed tables into one wide table on a common id, losing no rows
- Merge a handful of lookups (region, tier, manager) onto a base table in one step
- Combine 3+ inputs that a plain two-input join can't reach without chaining
Examples
Three tables on one key
input_1.account_id = input_2.account_id = input_3.account_id
Output keeps every account, null-filling the inputs that didn't have it.
Keep only complete rows
Only keep rows that match across all inputs
Flips to an inner join: a row survives only when every input matched.
By record position
Pair row 1 of every input, then row 2…
No keys needed; shorter inputs come back null for the extra rows.
Tips
- Set the number of inputs (2–16) with the − / + stepper, then connect every input you add; the canvas grows a handle per input.
- Each key row names one key column per input; add more key rows for a composite key. Null keys never match.
- The key column is coalesced into one output column per key; each input's other columns follow, and a repeated name is suffixed by its input number (amount, amount_2, amount_3).
- The output grid keeps/drops, renames, reorders and retypes any column, including the coalesced keys.
- Turn on Case-insensitive text keys to match Apple with apple; emitted values keep their original casing.