Join tables

Data & VariablesLow risk

Match two tables on a key column, or list the rows that have no match

Inputs

Name	Type	Required	Default	Description
First Table `leftTableName`	`variable`	Required	`—`	—
Second Table `rightTableName`	`variable`	Required	`—`	—
First Table Key Column `leftKey`	`string`	Required	`—`	—
Second Table Key Column `rightKey`	`string`	Optional	`—`	Leave empty when both tables use the same column name
Keep `joinType`	`enum`	Optional	`inner`	— `innerleftleftOnly`
Match Case `caseSensitive`	`boolean`	Optional	`false`	—
Prefix For Second Table Columns `rightPrefix`	`string`	Optional	`—`	Applied only where a column name exists in both tables
Output Variable `outputVariable`	`variable`	Optional	`joinedTable`	—