Join Tool ⭐️

Perform joins similar to Excel's VLOOKUP; merge data from different tables based on specific conditions.

Updated over a week ago

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

  1. Add a Join tool to your Canvas.

  2. Select the type of Join you want to perform. Savant offers four types of joins: Left Join, Inner Join, Outer Join, and Cross Join.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

Did this answer your question?