Join Data

Join Data can be understood as a type of “column merge,” but unlike simple concatenation, it requires matching join columns from both datasets. The join result can also be customized by choosing different columns and join methods, as shown below:

Join Type	Description
Inner Join	Joins only the intersection of matching rows on the join key.
Left Join	Outputs all rows from the left table and joins matching columns from the right table.
Full Join	Joins the union of rows on the join key.

In the example above, the two datasets are retail information and product master data. In the product master dataset, Product ID is the unique primary key.

To enrich the retail information with data from the product master dataset, choose Product ID as the join field and use a Left Join.