1 ×

Cell Replacer

StreamableKNIME Base Nodes version 4.3.0.v202012031743 by KNIME AG, Zurich, Switzerland

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.

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.
Copy metadata from replacement column: Check the box if any meta data from the "replacement" column should be retained in the output. This includes domain information, any color/size/shape handlers, names of the elements if the column represents a collection, etc. This option can only be selected if non-matches are represented as missing values (as opposed to copy the previous value). If in doubt, leave this option selected.

Input Ports

: Table containing column whose values are to be replaced.
: Dictionary table containing two columns: one lookup column and one replacement column.

Output Ports

: Input table with replaced target column.

Best Friends (Incoming)

Table Creator (12 %)
GroupBy (6 %)
Row Filter (5 %) Streamable
Column Filter (4 %) Streamable
String Manipulation (4 %) Streamable
Show all 393 recommendations

Best Friends (Outgoing)

Joiner (12 %)
Row Filter (7 %) Streamable
GroupBy (7 %)
Column Filter (6 %) Streamable
Rule Engine (4 %) Streamable
Show all 400 recommendations

Workflows

01_Amazon_S3_Remote_File_Example (KNIME Hub)
01_Amazon_S3_Remote_File_Example (KNIME Hub)
01_Data_Lineage_via_KNIME_WebPortal (KNIME Hub)
01_Guided_Visualization (KNIME Hub)
01_Guided_Visualization (KNIME Hub)
Show all 203 workflows

Installation

To use this node in KNIME, install KNIME Base nodes from the following update site:

KNIME 4.3

A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

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.