Join

Combines two tables side by side by matching rows on a shared key column, like a VLOOKUP that brings across every column at once. Rows that match are merged into one; what happens to unmatched rows depends on the join type you pick.

Inputs

Input	Accepts	Required
`Table1`	Table	Yes
`Table2`	Table	Yes

Outputs

Output	Produces
`Result`	Table

Settings

Typed in on the node or set by the assistant, not wired.

Setting	Default	Notes
`JoinColumn`	—	Choose a column from the connected table. The key column used to match rows. It must exist with the same name in both tables (rename first if it does not).
`JoinType`	`Inner`	One of Inner, Left, Right, Full. Default Inner. Inner keeps only matched rows; Left keeps every row of the first table; Right keeps every row of the second; Full keeps everything from both.

Example

Your Sales table has actual revenue by Region, and a separate Targets table has quota by Region. Set JoinColumn to Region and leave JoinType as Inner. The result, one row per region with both actuals and targets, appears as its own tab, and an attainment column is one formula away.

Tips

If both tables have a column with the same name (other than the key), the second table's copy is renamed with a _2 suffix, e.g. Amount_2.
Use Left when the first table is your master list and you want blanks, not dropped rows, where the second table has no match.