StreamableKNIME Base Nodes version 3.6.0.v201807061308 by KNIME AG, Zurich, Switzerland
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.
To use this node in KNIME, install KNIME Base Nodes from the following update site: