Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • Joiner
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.

External resources

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

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:

  1. Go to item

Related workflows & nodes

  1. Go to item
  2. Go to item
  3. Go to item

No known nodes available

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits