The JOIN component merges two tables by associating the columns in the tables and determines the output columns. This component works similarly to the JOIN statement of SQL.

You can configure the component only in the Machine Learning Platform for AI (PAI) console.
Parameter Description
Join Type The join type. Valid values: Left Join, Inner Join, Right Join, and Full Join.
Join Condition The join conditions, which is in the format of equations. You can manually add or remove join conditions.
Columns Output by Left Join Table The output columns you selected from the left table.
Columns Output by Right Join Table The output columns you selected from the right table.