← All features

Canvas nodes

Joiner

Combine two tables using matching keys in an inner or left join.

How it works

Connect two tables and select their matching key fields. An inner join keeps matched rows, while a left join also keeps unmatched rows from the first table.

Click Joiner on Canvas, then change Join in the inspector. An inner join keeps orders with a matching customer.

Simple example

Connect orders as the left input and a customer lookup as the right input. Select Customer ID on each side and choose Inner join to add customer details to orders that have a match.

Joiner selected in n0is Canvas in the simple example.
n0is Canvas · Sample dataView full size

Input 1

First 5 of 6 rows
Order IDRegionAmountStatusCustomer IDReference
A101West140ShippedC1Retail
A102East85PendingC2Outlet
A103West220ShippedC3Retail
A104North38CancelledC9Retail
A105East126ShippedC2Outlet

Input 2

3 rows
Customer IDCompanySegment
C1Birch SupplyRetail
C2Cedar GoodsWholesale
C3Moss MarketRetail

Node output

5 rows
Order IDRegionAmountStatusCompanySegment
A101West140ShippedBirch SupplyRetail
A102East85PendingCedar GoodsWholesale
A103West220ShippedMoss MarketRetail
A105East126ShippedCedar GoodsWholesale
A106West99PendingBirch SupplyRetail

Complex workflow

To check for missing lookup entries, connect orders first and a lookup with one row per customer second. Choose Left join and set the key columns, even if their headers differ. All orders stay in the output, including those with no matching lookup details.

Joiner selected in n0is Canvas in the complex workflow.
n0is Canvas · Sample dataView full size

Input 1

First 5 of 6 rows
Order IDRegionAmountStatusCustomer IDReference
A101West140ShippedC1Retail
A102East85PendingC2Outlet
A103West220ShippedC3Retail
A104North38CancelledC9Retail
A105East126ShippedC2Outlet

Input 2

3 rows
Account KeyCompanySegment
C1Birch SupplyRetail
C2Cedar GoodsWholesale
C3Moss MarketRetail

Node output

First 5 of 6 rows
Order IDRegionAmountStatusCompanySegment
A101West140ShippedBirch SupplyRetail
A102East85PendingCedar GoodsWholesale
A103West220ShippedMoss MarketRetail
A104North38Cancelled——
A105East126ShippedCedar GoodsWholesale