Lookup Appender (Multi Column)

Uses a lookup table with multiple columns, appending all of the selected columns to the end of the source data based on a lookup code

Select the "code" in the source table, and the lookup code in the lookup table, and specify the set of "output columns" to be appended to the data from the lookup table


6 August 2021 @takbb Brian Bates

Options

Append columns
Specify columns to be "looked up" and appended to source data table
Source "code" column
Enter the column containing the item to be looked up in the source data
Lookup code column
Enter the column representing the lookup 'index' item in the lookup table

Input Ports

Icon
Input data table
Icon
Lookup table containing at least one "code" column, and one or more utput values to be returned for each code

Output Ports

Icon
The original input data table plus appended looked-up values

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: 2021-08-07
Last update: 2024-04-28
Created with KNIME version: v4.4.0

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

Try NodePit Runner!