Hub
NodeNode / Manipulator

Joiner

Manipulation Column Split & Combine
Drag & drop
Like
Copy short link

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.

Node details

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.

Extension

The Joiner node is part of this extension:

Related workflows & nodes