This Node Is Deprecated — This node is kept for backwards-compatibility, but the usage in new workflows is no longer recommended. The documentation below might contain more information.
This node replaces the cells in a selected column by elements of a dictionary. The cell is compared against the keys in the dictionary file and - given that a matching key is found - the cell content is then replaced by the value of the respective dictionary entry.
The dictionary must be plain text file, whereas rows in the file correspond to entries in a dictionary. Each line should be of the format
value, key1, key2, key3, ...
The value string corresponds to the replacement string (matching keys are replaced with this value).The keys are given by the strings after the value (key1, key2, ... in the example), i.e. there are multiple keys possible. If no key matches the input string, the cell content remains the same. Only exact matches are possible.
Note, the dictionary does not get saved to the archive when the flow is exported. The dictionary file needs to be saved/exported separately. In general it's advisable to use the Cell Replacer node as this has a dedicated dictionary port.
Options
Popular Predecessors
Number To String16 %CSV Writer6 %String To Number3 %Cell Splitter3 %- String Replacer2 %
- Numeric Binner1 %
- String Manipulation1 %
- Number to String1 %
Table Row To Variable Loop Start1 %- Column Filter1 %
String Replace (Dictionary)1 %Table Row to Variable1 %XLS Reader1 %Excel Reader (XLS)1 %Concatenate (Optional in)< 1 %Number To String (PMML)< 1 %- ARFF Reader< 1 %
Joiner< 1 %Table Column to Variable< 1 %- Concatenate< 1 %
Row Splitter (deprecated)< 1 %- Normalizer< 1 %
- Rule Engine< 1 %
- Joiner< 1 %
- Split Collection Column< 1 %
Column Appender< 1 %- Partitioning< 1 %
Table Writer< 1 %- Column List Loop Start< 1 %
- Table View (JavaScript)< 1 %
- Table Reader< 1 %
Cell Replacer< 1 %- Correlation Filter< 1 %
- Sorter< 1 %
- Rule-based Row Splitter< 1 %
- Dictionary Replacer< 1 %
- Excel Reader< 1 %
Variable to Table Column< 1 %- Table Creator< 1 %
- Java Snippet< 1 %
- Cell Splitter By Position< 1 %
List Files< 1 %- Nominal Value Row Splitter< 1 %
- Math Formula (Multi Column)< 1 %
- Strings to Document< 1 %
- Table Column to Variable< 1 %
- CSV Writer< 1 %
- Table Manipulator< 1 %
- XML Reader< 1 %
- Reference Column Filter< 1 %
- Missing Value Column Filter< 1 %
- GroupBy< 1 %
- Column Splitter< 1 %
- Value Counter< 1 %
Loop End< 1 %- Extract Missing Value Cause< 1 %
- Missing Value< 1 %
- Math Formula< 1 %
- Cell Splitter< 1 %
- String to Number< 1 %
- Pivot< 1 %
- Number to String (PMML)< 1 %
- String Manipulation (Multi Column)< 1 %
- Document Data Extractor< 1 %
- Multiple Selections (legacy)< 1 %
- Date&Time to String< 1 %
- Table Writer< 1 %
- DB Merge< 1 %
- Column Combiner< 1 %
- Category to Number< 1 %
- Column Merger< 1 %
Column Rename< 1 %- RowID< 1 %
- Table Transposer< 1 %
XLS Writer< 1 %- Extract Variables (Data)< 1 %
Table Column to Variable< 1 %Variable Loop End< 1 %- Reference Column Splitter< 1 %
- Scatter Plot (JavaScript)< 1 %
- JSON to Table< 1 %
- String to Date&Time< 1 %
File Reader< 1 %Line Reader< 1 %- k-Means< 1 %
- Auto-Binner< 1 %
- Binner (Dictionary)< 1 %
- Case Converter< 1 %
- Column Aggregator< 1 %
- Column Name Extractor< 1 %
- Column Rename (Regex)< 1 %
- Column Resorter< 1 %
- Constant Value Column< 1 %
- Nominal Value Row Filter< 1 %
Row Filter (deprecated)< 1 %- Reference Row Filter< 1 %
- String Splitter (Regex)< 1 %
- Number Rounder< 1 %
- Rule-based Row Filter< 1 %
- Statistics< 1 %
- IF Switch< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Time to String (legacy)< 1 %
Table Row to Variable< 1 %- Edit Nominal Domain< 1 %
- Duplicate Row Filter< 1 %
- Rule Engine (Dictionary)< 1 %
- Crosstab< 1 %
- Column Expressions< 1 %
Excel Reader (XLS)< 1 %- Table Row to Variable< 1 %
- CSV Reader< 1 %
- File Reader< 1 %
- Table Row to Variable Loop Start< 1 %
- Column Appender< 1 %
- Path to String (Variable)< 1 %
- String to Path (Variable)< 1 %
- Google Sheets Reader< 1 %
- Linear Correlation< 1 %
- Path to String< 1 %
- Create Collection Column< 1 %
CSV Reader< 1 %- Ungroup< 1 %
Excel Reader (XLS)< 1 %Dictionary tagger< 1 %- Bag Of Words Creator< 1 %
- String Matcher< 1 %
- Rule Engine Variable (Dictionary)< 1 %
- Create Temp Folder< 1 %
Database Reader< 1 %- Loop End (Column Append)< 1 %
- Decision Tree Predictor< 1 %
- Column Renamer (Dictionary)< 1 %
- Domain Calculator< 1 %
- Unpivot< 1 %
- Cache< 1 %
- Case Converter< 1 %
- File Chooser (legacy)< 1 %
Table Column to Variable< 1 %Recursive Loop Start (2 ports)< 1 %- Hierarchical Clustering< 1 %
- DBSCAN< 1 %
- Column Comparator< 1 %
- One to Many< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- String Manipulation (Variable)< 1 %
- Variable Expressions< 1 %
- Dictionary Replacer (File-based)< 1 %
- Punctuation Erasure< 1 %
- Replacer< 1 %
- Container Input (Table)< 1 %
- Variable to Table Row< 1 %
- Merge Variables< 1 %
- POS Tagger< 1 %
- Strings to Binary Objects< 1 %
Parameterized Database Query< 1 %- Fixed Width File Reader< 1 %
Table Reader< 1 %Gradient Boosted Trees Predictor< 1 %Random Forest Predictor< 1 %- Cross Joiner< 1 %
- Numeric Row Splitter< 1 %
- Empty Table Switch< 1 %
- SDF Reader< 1 %
PMML Ensemble Predictor< 1 %- Number Filter< 1 %
- String to Term< 1 %
- Term to String< 1 %
MongoDB Reader< 1 %- R Snippet< 1 %
- Date Field Extractor (legacy)< 1 %
- XPath< 1 %
- Auto-Binner (Apply)< 1 %
String To Number (PMML)< 1 %- String Configuration< 1 %
- Column Filter (legacy)< 1 %
- Python Source (legacy)< 1 %
XML Reader< 1 %- Variable to Table Column< 1 %
- Rank< 1 %
- Fingerprint Clustering< 1 %
- Load text-based files< 1 %
- R Snippet< 1 %
- Advanced MolConverter< 1 %
- Wait...< 1 %
- Create File Name (legacy)< 1 %
Database Connection Table Reader< 1 %Generic Loop Start< 1 %Regression Predictor< 1 %- Column Auto Type Cast< 1 %
- Lag Column< 1 %
- Double to Integer< 1 %
- Reference Row Splitter< 1 %
- Missing Value (Apply)< 1 %
- Row Sampling< 1 %
- End IF< 1 %
- Create Temp Dir (legacy)< 1 %
- Color Manager< 1 %
- Molecule Type Cast< 1 %
- Java Snippet (simple)< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Category to Class< 1 %
- Tika Parser URL Input< 1 %
- N Chars Filter< 1 %
- Sentence Extractor< 1 %
Strings To Document< 1 %- Tags to String< 1 %
- String Input (legacy)< 1 %
- Container Input (JSON)< 1 %
- JSON Path< 1 %
- Columns to JSON< 1 %
- Python Edit Variable (legacy)< 1 %
- Collection to String< 1 %
Element Selector< 1 %- Binary Objects to Strings< 1 %
- URI to String< 1 %
- URL to File Path (Variable)< 1 %
Variable to Table Column< 1 %- Java Edit Variable< 1 %
- Group Loop Start< 1 %
- X-Aggregator< 1 %
- Cluster Assigner< 1 %
Scorer< 1 %- SMOTE< 1 %
Tree Ensemble Predictor< 1 %- Random Forest Learner< 1 %
- Category to Number (Apply)< 1 %
- Number to Category (Apply)< 1 %
- Table Validator< 1 %
Double To Int< 1 %- Constant Value Column Filter< 1 %
- Filter Apply< 1 %
- Denormalizer< 1 %
- String to Number (PMML)< 1 %
- Set Operator< 1 %
- Decision Tree to Ruleset< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Extract Table Spec< 1 %
- Amazon Translate< 1 %
- DB Reader< 1 %
- DB Query Reader< 1 %
- Counter Generation< 1 %
- Empty Table Creator< 1 %
- k-Medoids< 1 %
- Prediction Fusion< 1 %
Read XLS Sheet Names< 1 %Read Excel Sheet Names (XLS)< 1 %Excel Writer (XLS)< 1 %- NGram Creator< 1 %
- Tika Language Detector< 1 %
- Dictionary Filter< 1 %
- Stop Word Filter< 1 %
- Tika Parser< 1 %
- Dictionary Tagger< 1 %
- Weka Predictor (3.7)< 1 %
- Column Filter Configuration< 1 %
- String to JSON< 1 %
Python Script (2⇒1)< 1 %- R Source (Table)< 1 %
- Get Git Commit Details< 1 %
- Date&Time Difference< 1 %
Extract Date&Time Fields< 1 %- Date&Time-based Row Filter< 1 %
- Preset Date/Time (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- String to XML< 1 %
- Table to HTML String< 1 %
- HTTP Result Data Extractor< 1 %
- Normalize Plates (POC)< 1 %
- Spell Checker (simple)< 1 %
- Create Directory (legacy)< 1 %
- File Reader (Complex Format)< 1 %
- Variable Creator< 1 %
Loop End (2 ports)< 1 %Recursive Loop End< 1 %Recursive Loop Start< 1 %- Hierarchical Cluster Assigner (local)< 1 %
- Equal Size Sampling< 1 %
- Data Explorer< 1 %
- Numeric Outliers< 1 %
- Term Co-Occurrence Counter< 1 %
- Diacritic Remover< 1 %
- RegEx Filter< 1 %
- Weka Cluster Assigner (3.6) (legacy)< 1 %
- Local File Browser Configuration< 1 %
- String Widget< 1 %
- Text Output Widget (legacy)< 1 %
- Legacy Date&Time to Date&Time< 1 %
Regex Extractor< 1 %
Views
- This node has no views
Workflows
03_Visualizing_Git_Statistics_for_Guided_AnalyticsKNIME Hub
30_xplan sf dbconv_opex_service_historyKNIME Hub- 31_xplan sf dbconv_opex_consent_tableKNIME Hub
- Classification_Models_Economic_Stimulus_PackageKNIME Hub
- Classification_Models_Economic_Stimulus_PackageKNIME Hub
- Show all 22 workflows
Links
- Finding and replacing part of a stringby armingrudd on 2019-04-24forum.knime.com/p/59372
- Renaming values in a columnby oole on 2019-02-14forum.knime.com/p/54547
- Dictionary replace part of a stringby HansS on 2021-02-01forum.knime.com/p/114777
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.