Join

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Join

Description

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

 

Inputs

Two.

 

Example

Joining these two datasets by the ID column in each:

 

join example

 

Gives:

 

join example

 

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.

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.

 

Top Include top non-matching rows checked

Bottom Include top non-matching rows checked

Also known as:

No

No

Inner join

No

Yes

Right outer join

Yes

No

Left outer join

Yes

Yes

Full outer join

 

Notes

If there are 10k rows or less in both datasets, Easy Data Transform will try to guess sensible default values for Top key column and Bottom key column based on column header names and contents.

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.

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

Use Row Num to create a unique key column.

Use the Cross transform for cross joins.

Cascade multiple joins to join more than 2 datasets.

 

join-multiple-tables

 

See also

Cross

Stack

Lookup

Merge datasets