DB Joiner

This node joins two DB Data tables. The join is based on the joining columns of both tables.

Options

Join mode
If a row from the top table cannot be joined with a row from the bottom 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 bottom table with missing values if no matching row exists in the bottom table. Likewise, a RIGHT (OUTER) JOIN will fill up the columns from the top table with missing values if no matching row in the top table exists. A FULL (OUTER) JOIN will fill up columns from both the top and bottom table with missing values if a row cannot be joined.
Match
Defines the logic for the matching criteria:
  • Match all of the following: A row of the top input table and a row of the bottom input table match if they match in all specified column pairs.
  • Match any of the following: A row of the top input table and a row of the bottom input table match if they match in at least one specified column pairs.
Joining columns
Select the columns from the top input ('left' table) and the bottom input ('right' table) that should be used for joining. You must make sure, that the type of selected columns matches.
  • Top input ('left' table): Select the column from the top input table that should be used to compare with the column selected for the bottom input.
  • Bottom input ('right' table): Select the column from the bottom input table that should be used to compare with the column selected for the top input.
Top input ('left' table)
Select the left columns for the select clause in the join statement.
Bottom input ('right' table)
Select the right columns for the select clause in the join statement.
Duplicate column handling
The option allows you to change the behavior if the include lists of both input tables contain columns with the same name.
  • Remove duplicates: Only the columns from the top input table will show up in the output table.
  • Append suffix (automatic): Append a suffix to the duplicate column names from the bottom input table so that they also show up in the output table.
  • Append custom suffix:: Append a suffix to the duplicate column names from the bottom input table so that they also show up in the output table.
  • Fail: Don't allow to execute this node if there are duplicate column names in the include lists.
Custom suffix
The suffix to be added to the column name of the right table
Remove joining columns from top input ('left' table)
The option allows filtering the top ('left' table) joining columns, i.e. the joining columns defined in the Joiner Settings tab will not show up in the output table.
Remove joining columns from bottom input ('right' table)
The option allows filtering the bottom ('right' table) joining columns, i.e. the joining columns defined in the Joiner Settings tab will not show up in the output table.

Input Ports

Icon
DB Data referencing the left part of the joined output DB Data table.
Icon
DB Data referencing the left part of the joined output table.

Output Ports

Icon
DB Data referencing the joined DB Data table.

Popular Predecessors

Popular Successors

Views

This node has no views

Workflows

Links

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.

Installation

To use this node in KNIME, install the extension KNIME Database from the below update site following our NodePit Product and Node Installation Guide:

v5.5

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

Plugin provider: KNIME AG, Zurich, Switzerland
Plugin version: 5.5.0.v202505260608
On NodePit since: 2025-07-02
Last update: 2025-07-20
Tags: Streamable
KNIME versions: Since v3.7

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!