Joiner

This functions conducts a join operation, merging columns from two tables. Users can choose from several types of joins listed, and the “Left Fields” and “Right Fields” display columns from their respective input tables.

• Inner Join: Retrieves rows where there is a match in both tables.
• Left Join (or Left Outer Join): Retrieves all rows from the left table and matching rows from the right table. If there is no match, NULL values are returned for columns from the right table.
• Right Join (or Right Outer Join): Retrieves all rows from the right table and matching rows from the left table. If there is no match, NULL values are returned for columns from the left table.
• Full Join (or Full Outer Join): Retrieves all rows when there is a match in either the left or right table. If there is no match, NULL values are returned for columns from the table without a match.

How to use a Joiner?

Step 1: Choose the two source files you want to perform the join operation.

Step 2: Select the desired tables and columns, specify the join type, and define the join condition.

Users can include additional join expressions by selecting the “+ Add Join” tab, considering that we have three source files. This implies that for two source tables, we can have one expression, and for three source tables, we can have two join expressions, and so forth.

Note: A maximum of 5 expressions can be created, which means up to 6 sources can be utilized.

Step 3: Click “Save” to proceed.

For example:

• We use two tables: the “Retail” and the “Online retail order.”
• We join tables using an inner join operation, taking “product_id” as a column in both tables.

Preview