0 ×

Joiner (deprecated)

DeprecatedKNIME Base Nodes version 4.3.1.v202101261649 by KNIME AG, Zurich, Switzerland

This node joins two tables in a database-like way. The join is based either on the row IDs of both tables or on the row ID of the first table and an arbitrary column from the second table.
If you want to join based on two columns, you first have to set the row IDs from either table by using the Row ID node.

Options

Join column from second table
Select the column from the second input table that should be used for joining. You may selected a real column or the table's row ID here. You must make sure, that the type of selected column matches the type of the row ID in the first table! If e.g. the row IDs in the first table are StringCells and the selected column from the second table are IntCells joining will fail although they may contain the same numbers.
Duplicate column handling
The option allows you to change the behaviour if both input tables contain columns with the same name. If "Don't execute" is selected, the node will not be executed i.e. it stays red. The second choice is to filter the duplicate columns, i.e. only the columns from the first input table will show up in the ouput table. As a third option you can append a suffix to duplicate column names so that they are also available at the output table.
Join mode
If a row from the first table cannot be joined with a row from the second table (and vice versa) there are several options of handling this situation. After an Inner Join only matching rows will show up in the output table. A Left Outer Join will fill up the columns that come from the second table with missing values if no matching row exists in the second table. Likewise, a Right Outer Join will fill up the columns from the first table with missing values if no matching row in the first table exists. A Full Outer Join will fill up columns from both the first and second table with missing values if a row cannot be joined.
Multiple-match row ID suffix
If several rows from the second table match to one row from the first table, the row ID from the first table's row is extended by this suffix and a number. In some cases it is necessary to manually change the suffix if the extended row ID is equal to an existing row ID (which causes DuplicateRowKeyExceptions).

Input Ports

Icon
Table contributing to the left part of the output table
Icon
Table contributing to the right part of the output table

Output Ports

Icon
Joined Table

Best Friends (Incoming)

Installation

To use this node in KNIME, install KNIME Base nodes from the following update site:

KNIME 4.3

A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.