Join
Add another data set to an existing one by appending columns.
Add another data set to an existing one by appending columns. When joining data, ensure that there is at least one common column in both data sets. The common column is known as a key column.
Input and output
To use this tool, you need two data sets.
When you run this tool, it appends columns to the primary data set based on the secondary data set. The data type must be the same in both key columns.
When to use this tool
Use when you need to combine two data sets.
If you want to combine data sets but restrict it to only matching columns, use the Union tool instead.
Select the join type to combine columns:
Left: Values appear in the left data set output when joined, regardless of a match.
Right: Values appear in the right data set output when joined, regardless of a match.
Inner: Values must exist and match in both data sets for the results to appear in the output.
Left anti: Values from the left table that don’t have any matching rows from the right table appear in the output.
Full outer: Returns all records in both the top (Left) and bottom (Right) data sets, regardless of a match.
Learn more about the join types...
In the advanced settings, you can select different comparison operators. Equal is the default operator. You can choose from the following operators to filter:
Operator | Text | Numeric | Boolean | Dates |
|---|---|---|---|---|
Equal | Supported | Supported | Supported | Supported |
Less than | Not supported | Supported | Not supported | Supported |
Less than or equal | Not supported | Supported | Not supported | Supported |
Greater than | Not supported | Supported | Not supported | Supported |
Greater than or equal | Not supported | Supported | Not supported | Supported |
Like | Supported | Not supported | Not supported | Not supported |
Note: If you select the Like operator, the pattern type appears.
Example
You have two data sets. The Universe column from the top and bottom data sets are the related columns that will allow us to merge the top and bottom nodes together.
