Hub
ComponentComponent

Lookup Appender (Multi Column)

Brian Bates profile image

Last edited: 

Drag & drop
Like
Use or download
Copy short link
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

Component details

Input ports
  1. Type: Table
    Source data
    Input data table
  2. Type: Table
    Lookup Table
    Lookup table containing at least one "code" column, and one or more utput values to be returned for each code
Output ports
  1. Type: Table
    Output
    The original input data table plus appended looked-up values

Used extensions & nodes

Created with KNIME Analytics Platform version 4.4.0
  • KNIME Base nodes Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.0

    knime
  • KNIME Quick Forms Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.0

    knime