Joiner

This node combines two tables similar to a join in a database. It combines each row from the top input port with each row from the bottom input port that has identical values in selected columns. Rows that remain unmatched can also be output.

Input ports

1. Type: Table
   Left table
   Left input table
2. Type: Table
   Right table
   Right input table

Output ports

1. Type: Table
   Join result
   Either all results or the result of the inner join (if the unmatched rows are output in separate ports)
2. Type: Table
   Left unmatched rows
   Unmatched rows from the left input table (top input port). Inactive if "Output unmatched rows to separate ports" is deactivated.
3. Type: Table
   Right unmatched rows
   Unmatched rows from the right input table (bottom input port). Inactive if "Output unmatched rows to separate ports" is deactivated.

External resources

• KNIME E-Learning Course: Join: inner join, right outer join, left outer join, full outer join