Merge two datasets using Join operation

A join operation merges two existing datasets together based on matching values from one or multiple columns. You can choose to use different types of joins, depending on the output you want.

Join two datasets

You can easily find the Join operation in the toolbar.

Choose the right table

When you click the Join button, you need to first select a dataset as the right table.

In this example, you want to join the People table with Orders as the right table.

Select the join keys

The goal is to join these tables by using the Region column from both tables, so you select the Region column from each table.

You can also select multiple columns to perform the join by clicking the "+ ADD KEY".

Join types

A join type specifies how a merge operation will be performed. The following table describes the available join types in QuickTable.

Join type	Icon	Description
Left join		Returns all matching rows and all rows from the left table.
Right join		Includes all rows from the right table and only matching rows from the left table.
Inner join		Returns rows that fully match across both tables.
Outer join		Returns all rows from both tables.
Cross join		Returns a cartesian product.(No need to configure join keys)

In this example, you want to keep all the data in the Orders table, and merge the "Person" column from People. So you can choose "Left join" and check the Person column in the Output columns.

Rename output columns

If you want to modify the name of the column in the result, you can do so directly here:

Click the Save button, you will get your expected result.