Join Data

Join Data can be commonly understood as "column concatenation". The difference is that join data needs to find the same join columns in both datasets for concatenation; and the concatenation forms are also diverse, and the final presented dataset can also have custom columns, as follows:

Join Method	Feature Description
Inner Join	Only joins the intersection in the join columns
Left Join	By default outputs all rows from the left table and joins the matching columns from the right table
Full Join	Joins the union in the join columns

As shown in the figure, the two datasets are retail information and product basic information respectively. For product basic information, the product number is the unique primary key.

We want to complete the products in retail information according to the information in product basic information, so we choose to use Product Number as the join field for left join.