Join
Join Tables
Matches rows from its Left and Right inputs on a key column and combines them into one table.
When to use it
Use it to bring a lookup table alongside your main data, for example adding customer or product details to a list of transactions.
In a pipeline
File InputJoin TablesExport Excel
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Join Type | select | Yes | inner |
| Left Column | select | Yes | — |
| Right Column | select | Yes | — |
Example
Add a region to each order
- Join Type=Inner Join
- Left Column=Customer
- Right Column=Customer
| Order | Customer |
|---|---|
| A-1 | C-100 |
| A-2 | C-200 |
| Order | Customer | Region |
|---|---|---|
| A-1 | C-100 | West |
The right input holds C-100 in West and C-300 in East, so only A-1 matches; Customer exists on both sides and keeps the left value.
Worth knowing
- The Left input is whatever is wired to the Left handle; with unlabelled connections, the first one connected is treated as left.
- When both sides share a column name, the left value is kept and the right column is dropped, so rename one side first if you need both.
- Left, Right and Full joins fill the missing side with null.
- Several matching rows on the right produce several output rows, which can make the result longer than the left table.