Join
Combine two tables based on common field
Last updated
Combine two tables based on common field
Last updated
Join allows for the combination of two datasets into a single table, based on a shared column.
Input
Output
Left Table - any table
Right Table - any table
Single table with merged data from Left Table and Right Table
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.