Join

Combine two tables based on common field

Join allows for the combination of two datasets into a single table, based on a shared column.

Input/Output

Input	Output
Left Table - any table Right Table - any table	Single table with merged data from Left Table and Right Table

Options

Option	Description
Left Field	Column in the Left table that shares values with the Right table
Right Field	Column in the Right table that shares values with the Left table
Join Type	Indicates how the table should be joined. Includes the following options: Left: keeps all rows in the Left table, discards and unmatched rows in the Right table Right: keeps all rows in the Right table, discards and unmatched rows in the Left table Inner: discards all rows in either table that do not have a match for in the other one. Outer: keeps all rows in both tables, regardless of whether matching rows are found. Cross: combines each row from the Left table with each row from the Right table
Match Option	By default, joins create new rows for each match found in between the Left and Right tables. This often results in a joined table with many more rows than either source table. To prevent that, for a Left or Right join you can choose to only match the first or last matched record, rather than creating a new record for each match. Match All (default): creates a new row for each matched. Match First: performs like a VLOOKUP in Excel, keeping the first matching record in the table and ignoring subsequent matches. Output table will have the same number of rows as the Left (Right) table for a Left (Right) join. Match Last: performs the same way as Match First, but keeps the last matching record instead.

Suggested Articles

💬Understanding the Join options in the Cascade Join tool