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

πŸ’¬pageUnderstanding the Join options in the Cascade Join tool

Last updated