The node has two inputs: a data table and a dictionary table.
From the data table select the column that is used to look up values in the dictionary table.
From the dictionary table select a column that contains the search keys or criteria.
When a lookup value matches an entry in the dictionary, cells from that row are appended to the data table. In case multiple rows match you can choose if you want to use the first match or the last match. If no rows match you can choose to insert missing values, match the next smaller value or match the next larger value.
Missing values are treated as ordinary values, i.e. they are valid as lookup and replacement value. The key column of the dictionary can also be a collection type. Then, the values in the collection act as alternative lookup values for the associated row.
In the output section you can select the columns in the dictionary table that shall be inserted in the output data table.
Options
Popular Successors
Row Filter (deprecated)11 %- Value Lookup10 %
- Excel Writer8 %
- Column Renamer7 %
- Column Filter6 %
- Joiner5 %
- Rule Engine4 %
- Column Expressions4 %
- GroupBy4 %
- Math Formula3 %
- Missing Value3 %
- Concatenate2 %
- Rule-based Row Splitter2 %
- String Manipulation2 %
- Row Aggregator2 %
- Rule-based Row Filter2 %
- Column Resorter2 %
Row Splitter (deprecated)1 %- CSV Writer1 %
- Column Merger1 %
- String to Number1 %
- Row Filter (Labs)1 %
- Nominal Value Row Filter1 %
- Table Manipulator< 1 %
- Pivot< 1 %
- Sorter< 1 %
- Column Combiner< 1 %
- Reference Row Filter< 1 %
- Column Aggregator< 1 %
- Duplicate Row Filter< 1 %
- Constant Value Column< 1 %
- Java Snippet< 1 %
- Cell Splitter< 1 %
- String Manipulation (Multi Column)< 1 %
- Google Sheets Updater< 1 %
- Bar Chart< 1 %
- Statistics View< 1 %
- Table View< 1 %
- Loop End< 1 %
- Table Writer< 1 %
- Reference Row Splitter< 1 %
- Number Rounder< 1 %
- Table Splitter< 1 %
- Math Formula (Multi Column)< 1 %
- Group Loop Start< 1 %
- PCA< 1 %
- Column Comparator< 1 %
- Double to Integer< 1 %
- Partitioning< 1 %
- Normalizer (PMML)< 1 %
- Cell Updater< 1 %
- Pie Chart< 1 %
- Nominal Row Filter Configuration< 1 %
- String to Date&Time< 1 %
- Table Row to Variable< 1 %
Cell Replacer< 1 %- Category to Number< 1 %
- Number to String< 1 %
- Column Appender< 1 %
- Lag Column< 1 %
- Domain Calculator< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Normalizer< 1 %
- Rank< 1 %
- RowID< 1 %
- String Replacer< 1 %
- Cell Extractor< 1 %
- Table Updater< 1 %
- Table Difference Finder< 1 %
- Value Counter< 1 %
- Data Explorer< 1 %
- Statistics< 1 %
- Color Manager< 1 %
- Heatmap< 1 %
- Histogram< 1 %
- Line Plot< 1 %
- Excel Reader< 1 %
- Google Sheets Writer< 1 %
- JSON Path< 1 %
- Data to Report (BIRT)< 1 %
- Date&Time Difference< 1 %
- Date&Time to String< 1 %
- Date&Time Part Extractor< 1 %
- Date&Time-based Row Filter< 1 %
- Date&Time Shift< 1 %
Views
- This node has no views
Workflows
00_Combine_Clean_and_Summarize_Spreadsheet_DataKNIME Hub- 01_DataViz, IQR & GenAI for Fraud DetectionKNIME Hub
- 01_Flow Variable and Component - ExerciseKNIME Hub
- 01_Flow Variable and Component - ExerciseKNIME Hub
- 01_Flow Variable and Component - ExerciseKNIME Hub
- Show all 450 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.