About the Join Tool
The Join tool combines the output from two separate steps of your analysis into one based on configurable matching criteria.
Add a Join tool
1. Navigate to your analysis.
2. Click this icon.
3. Click Join.
👉 Note: You may need to manually connect the second table to the second input node of the Join tool.
Configuration
Add a Join tool to your Canvas.
Select the type of Join you want to perform. Savant offers four types of joins: Left Join, Inner Join, Outer Join, and Cross Join.
Since the Join Tool does not have a specific left input, users can decide which table input they want to act as the Left Table for the join operation.
To perform a join, configure the Rules for matching records between the two tables. Use the dropdowns provided for each table input to select the columns you want to join on and the operator to use for the join condition.
Adding Multiple Join Conditions: If needed, you can add multiple join conditions by clicking the "Add" button below the join conditions. Set the appropriate AND, or OR operator as necessary.
Click Apply.
Types of Joins
Join Type | Description |
Left Join | Returns all rows from the left table and matching rows from the right table. |
Inner Join | Returns only the rows with matching values in both tables based on the join condition. |
Outer Join | Returns all rows from both tables and includes NULL values for non-matching rows. |
Cross Join | Returns the Cartesian product of both tables, combining each row from the first table with every row from the second tab |
Left Join
Inner Join
Outer Join
Cross Join
Operators
Operator | Description | Example (Assuming Join on "ID" Column) |
= | Equal to | Joins rows where the "ID" values are identical in both data sets. |
!= | Not equal to | Joins rows where the "ID" values are different in the two data sets. |
> | Greater than | Joins rows where the "ID" value in one data set is greater than the "ID" value in the other data set. |
>= | Greater than or equal to | Joins rows where the "ID" value in one data set is greater than or equal to the "ID" value in the other data set. |
< | Less than | Joins rows where the "ID" value in one data set is less than the "ID" value in the other data set. |
<= | Less than or equal to | Joins rows where the "ID" value in one data set is less than or equal to the "ID" value in the other data set. |