Lookup and Add Columns

This node uses a column in the first input as a key to lookup data and concatenate either one or all columns from the corresponding row in the second input. The value in the key column is used to match one of the rows in the lookup data table using the lookup column. If the lookup column is a molecule (i.e., Maestro, Sdf, or Pdb), then the key value will be matched with the molecule name/title. Either one selected column or all columns of the lookup data (depending on the dialog box setting) will be included in the output. Keys from the first input that fail to match are given blank (or zero) values. Note: The second input needs to have more than one column for this node to configure properly.

Options

Key column: The column from the first input that is used as a key to lookup into the Lookup column of the second input
Lookup column: The column from the second input that is used to lookup.
Include column: The column that is added on to the output if Include One Column is set.
Include one column: If checked, the output will consist of the first input concatenated with the include column from the second input row which matches the key in the lookup column.
Include all columns: If checked, the output will consist of the first input concatenated with all columns from the second input row which matches the key in the lookup column.
Add String to column names in Input 2 (if duplicate): This string is added to the output column name if it has a duplicate
Use Hash: If checked, the execution of the node uses a hash table in memory to keep all of the necessary data from the second input used to lookup. Otherwise, for each lookup, the entire second input is scanned until the first match is found.

Input Ports

: The entirety of this input is always included in the output
: This data is used as a lookup that matches the lookup column with the key column in the input data. This data is used selectively for each row in the output dependent on the matching keys from the input data and values in the lookup column.

Output Ports

: The concatenation of the input data and its matching lookup data. This lookup data can be either one or all columns in the second input.

Popular Predecessors

Popular Successors

Views

This node has no views

Workflows

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 Schrödinger Extensions for KNIME from the below update site following our NodePit Product and Node Installation Guide:

v5.2

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

Plugin provider: Schrödinger

Plugin version: 24.1.135.v202402072122

On NodePit since: 2023-12-06

Last update: 2024-04-15

KNIME versions: v5.2, v5.1, v4.7, v4.6, v4.5, v4.4, v4.3, v4.2, v4.1, v4.0, v3.7, v3.6

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

Try NodePit Runner!