Cell Replacer Joiner

A joiner implementation based on the Cell Replacer. Only works when the second table only has one occurrence of each join key. The Cell Replacer is streamable, so when multiple tables need to be joined extending this component with more inputs and Cell Replacers and then streaming the data can lead to increased performance compared to normal joiners in a row.

Options

Appended Columns
Columns that should be appended to the first table when the join columns match
Target Column
Enter Description
Lookup Column
Enter Description

Input Ports

Icon
The table to append the second table to.
Icon
The table to append to the first one.

Output Ports

Icon
First table with selected columns from the second table appended if join keys match.

Nodes

Extensions

Links

Download

To use this component in KNIME, download it from the below URL and open it in KNIME:

Download Component
On NodePit since: 2022-10-06
Last update: 2024-04-26
Created with KNIME version: v4.5.2

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

Try NodePit Runner!