Join

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Join

Description

Join 2 inputs based on common (key) columns, e.g. on an email address or id column present in both inputs.

 

Inputs

2.

 

Options

The output depends on the vertical (Y-axis) position of the inputs.

Select Top key column for the column you want to match in the top input dataset.

Select Include top non-matching rows if you want to include in the output any rows in the top input with no matching value in the bottom input (a 'left join').

Select Bottom key column for the column you want to match in the bottom input dataset.

Select Include bottom non-matching rows if you want to include in the output any rows in the bottom input with no matching value in the top input (a 'right join').

 

Notes

If there columns with the same header name in both inputs, then these will be set for Top key column and Bottom key column as the default.

All values are treated as text and comparisons are case and whitespace sensitive. You can use Case to change the case and Trim to remove whitespace before the intersect.

You can use Concat Cols to join several columns together (e.g. 'first name' and 'last name' columns) to form a key column.

You can use Row Num to create a unique key columns.

 

See also

Cross

Stack