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.

Input ports

1. Type: Table
   Input Data
   The entirety of this input is always included in the output
2. Type: Table
   Lookup Data
   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

1. Type: Table
   Out-Port name
   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.