All About Join
Join lets you combine data from two different sources together.
This article covers:
- • How Do I Add Join Node?
- • Join Node Options
- • FAQ
How Do I Add The Join Node?
Add Join to any node in your Dataflow. Select any node and use the Transform (+) button to open the list of options to select Join. You could work with the node in the Dataflow tab or use the Properties panel.
Join Node Options
There are five Join type to choose from:
- Left Outer
- Right Outer
- Inner
- Full Outer
- Cross
For simplicity, we refer to data as left-side data (i.e., table 1) and right-side data (i.e., table 2).
1. Left Outer
This Join operation will include all unmatched rows from the left-side data and only the rows that intersect with the right-side data.
2. Right Outer
This Join operation will include all unmatched rows from the right-side data and only the rows that intersect with the left-side data.
3. Inner
This Join operation will include only the matched rows between the left and right-side data.
4. Full Outer
This Join operation will include all unmatched rows and matched rows from left to right-side data.
5. Cross
Cross join is a unique operation that will map each row from the left-side data to each row on the right-side data. Cross join is also known as the Cartesian product of rows.
Check out the links below for related articles:
