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
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.
Popular Predecessors
- Column Expressions5 %
- Duplicate Row Filter5 %
- Row Filter4 %
- Molecule Reader (to MAE)3 %
- Set Molecule Title3 %
- Column Renamer (Dictionary)3 %
- MAE-to-SD3 %
- Canvas Fingerprint Generation3 %
- Molecule-to-MAE2 %
- CSV Reader2 %
- Row Splitter2 %
Column Rename2 %- RDKit Canon SMILES2 %
- MAE-to-Smiles2 %
- GroupBy2 %
- SDF Reader2 %
- Lookup and Add Columns2 %
- Extract Properties2 %
- Table Creator2 %
- Column Combiner2 %
- Column Filter2 %
- Sorter2 %
- Reference Column Filter2 %
- Round Double2 %
- Column Splitter2 %
- Value Counter2 %
- SDF Extractor2 %
- Excel Reader2 %
- RDKit Diversity Picker2 %
- Table Difference Finder2 %
Number To String2 %File Reader2 %- String Manipulation2 %
- Hierarchical Clustering1 %
- Column Merger1 %
- Rule-based Row Filter1 %
- TF1 %
CSV Reader< 1 %- Compare Ligand Sets< 1 %
- Glide Sort Results< 1 %
- Column Aggregator< 1 %
- Dissimilarity Selection (from Matrix)< 1 %
- LigPrep< 1 %
Tautomerizer< 1 %- Column Resorter< 1 %
- Reference Row Splitter< 1 %
- Group MAE< 1 %
Desalter< 1 %- Extract Atom/bond Properties< 1 %
- Pose Entropy< 1 %
RRHO Entropy< 1 %- Setup Diagnosis< 1 %
- Speedy SMILES De-salt< 1 %
- Number Formatter< 1 %
- MarvinSketch< 1 %
Database Reader< 1 %Loop End< 1 %- Group Loop Start< 1 %
- Concatenate< 1 %
- Lag Column< 1 %
- Create Table Structure< 1 %
- String Replacer< 1 %
- Rule Engine< 1 %
Excel Reader (XLS)< 1 %Excel Reader (XLS)< 1 %Read Excel Sheet Names (XLS)< 1 %- R Snippet< 1 %
- RDKit Fingerprint< 1 %
- Multipart Encoded HTTP Entity Creator< 1 %
- Delete MAE Properties< 1 %
- Ungroup MAE< 1 %
- REOS Filter< 1 %
- RMSD< 1 %
- Category to Number< 1 %
- Reference Row Filter< 1 %
Joiner< 1 %- Table Manipulator< 1 %
- Missing Value< 1 %
- Math Formula< 1 %
Views
- This node has no views
Workflows
Binding site shape clusteringKNIME Hub- Binding site shape clusteringKNIME Hub
- Binding site shape clusteringKNIME Hub
- Clustering 1-2KNIME Hub
- Clustering 1-2KNIME Hub
- Show all 29 workflows
Links
- No links available
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.