The following node is available in the Open Source KNIME predictive analytics and data mining platform version 2.7.1. Discover over 1000 other nodes, as well as enterprise functionality at http://knime.com.

Cell Replacer

Replaces cells in a column according to dictionary table (2nd input). The node has two inputs: The first input contains a target column whose values are to be replaced using the dictionary table (2nd input). From the dictionary table, choose one column (or the rowID column) that is used as lookup criterion. Any occurrence in the target column (1st input) that matches the lookup value is replaced by the corresponding value of the output column, which is another column in the dictionary table.

Missing values are treated as ordinary values, that is, they are valid as lookup and replacement value. If there are duplicates in the lookup column in the dictionary table, the last occurrence (bottom most row) defines the replacement pair.

If the input/lookup column is a collection type, each of the contained values in the collection is a search element.

Dialog Options

Input table, Target column
The column in the first input table whose values will be replaced.
Dictionary table, Input (Lookup)
Search column in the second input table.
Dictionary table, Output (Replacement)
Column in the second input table containing the replacement values.
If no element matches use
Define how values in the input table, which do not match any search pattern, are treated. "Input" will leave the value unmodified, "Missing" replaces the value by a missing value.
Append/Replace Result Column
Select the checkbox and enter a new column name that will contain the mapped output. If unselected, the result will replace the target column.

Ports

Input Ports
0 Table containing column whose values are to be replaced.
1 Dictionary table containing two columns: one lookup column and one replacement column.
Output Ports
0 Input table with replaced target column.
This node is contained in KNIME Base Nodes provided by KNIME GmbH, Konstanz, Germany.