0 ×

Cell Replacer

StreamableKNIME Base Nodes version 3.7.1.v201901291053 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.

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 (17 %)
Cell Replacer (7 %) Streamable
Excel Reader (XLS) (5 %) Streamable
GroupBy (5 %)
Row Filter (5 %) Streamable
Column Filter (4 %) Streamable
File Reader (4 %) Streamable
String Manipulation (3 %) Streamable
Column Rename (3 %) Streamable
Joiner (2 %)
Concatenate (2 %) Streamable
Number To String (2 %)
String To Number (2 %) Streamable
CSV Reader (2 %)
Math Formula (2 %) Streamable
Rule Engine (2 %) Streamable
Table Reader (2 %) Streamable
Column List Loop Start (1 %)
Database Reader (1 %)
k-Means (1 %)
Missing Value (1 %)
Rule-based Row Filter (1 %) Streamable
Constant Value Column (1 %) Streamable
Column Combiner (1 %) Streamable
Column Resorter (1 %) Streamable
Sorter (< 1 %)
String Replacer (< 1 %) Streamable
Value Counter (< 1 %)
~~Cell Splitter~~ (< 1 %) Deprecated
Reference Row Filter (< 1 %)
Row Splitter (< 1 %) Streamable
~~Excel Reader (XLS)~~ (< 1 %) StreamableDeprecated
~~XLS Reader~~ (< 1 %) Deprecated
Loop End (< 1 %)
Java Snippet (< 1 %) Streamable
Counter Generation (< 1 %)
Column Appender (< 1 %) Streamable
Unpivoting (< 1 %)
RowID (< 1 %) Streamable
Transpose (< 1 %)
Database Connection Table Reader (< 1 %)
Concatenate (Optional in) (< 1 %) Streamable
Column Rename (Regex) (< 1 %) Streamable
Double To Int (< 1 %) Streamable
Pivoting (< 1 %)
String Replace (Dictionary) (< 1 %) Streamable
Empty Table Creator (< 1 %)
Column Merger (< 1 %) Streamable
Nominal Value Row Filter (< 1 %) Streamable
Ungroup (< 1 %) Streamable
Category To Number (< 1 %) Streamable
Column Aggregator (< 1 %) Streamable
String to Date&Time (< 1 %) Streamable
Case Converter (< 1 %) Streamable
Rule-based Row Splitter (< 1 %) Streamable
Variable to Table Row (< 1 %)
Java Snippet (simple) (< 1 %)
Add Empty Rows (< 1 %)
Cell Splitter (< 1 %)
Replacer (< 1 %) Streamable
Python Script (1⇒1) (< 1 %)
Legacy Date&Time to Date&Time (< 1 %) Streamable
Chunk Loop Start (< 1 %)
Auto-Binner (< 1 %)
Extract Column Header (< 1 %)
Cross Joiner (< 1 %) Streamable
Extract Missing Value Cause (< 1 %) Streamable
Row Sampling (< 1 %)
Date&Time to String (< 1 %) Streamable
Date&Time-based Row Filter (< 1 %) Streamable
String to Date/Time (legacy) (< 1 %) Streamable
List Files (< 1 %)
Variable Loop End (< 1 %)
Numeric Binner (< 1 %) Streamable
Insert Column Header (< 1 %)
HiLite Row Splitter (< 1 %)
Reference Row Splitter (< 1 %)
Round Double (< 1 %) Streamable
Rule-based Row Filter (Dictionary) (< 1 %) Streamable
Parallel Chunk Start (< 1 %)
Weka Cluster Assigner (3.7) (< 1 %)
Extract Date&Time Fields (< 1 %) Streamable
Date&Time Shift (< 1 %) Streamable
Derive Fields (< 1 %)
Create Collection Column (< 1 %) Streamable
Split Collection Column (< 1 %)
Variable to Table Column (< 1 %) Streamable
Table Row to Variable (< 1 %)
Table Row To Variable Loop Start (< 1 %)
Line Reader (< 1 %)
Counting Loop Start (< 1 %)
Group Loop Start (< 1 %)
Cluster Assigner (< 1 %) Streamable
Numeric Scorer (< 1 %)
Lag Column (< 1 %) Streamable
One to Many (< 1 %)
Linear Correlation (< 1 %)
Create Table Structure (< 1 %)
Partitioning (< 1 %)
Rank (< 1 %)
Regex Split (< 1 %) Streamable
Column Splitter (< 1 %) Streamable
Numeric Outliers (< 1 %)
Statistics (< 1 %)
Crosstab (< 1 %)
SDF Reader (< 1 %)
Math Formula (Multi Column) (< 1 %) Streamable
String Matcher (< 1 %)
Term To String (< 1 %)
JSON to Table (< 1 %)
Date&Time to legacy Date&Time (< 1 %) Streamable
Mask Date/Time (legacy) (< 1 %)
String to Date/Time (legacy) (< 1 %) Streamable
Time to String (legacy) (< 1 %) Streamable
XPath (< 1 %) Streamable
DateExtractor (< 1 %)
Canonical SMILES (< 1 %)
Example Data (< 1 %)
Expand Well Position (< 1 %)
Outlier Removal (< 1 %)
MolConverter (< 1 %) Streamable
String to URI (< 1 %)
Inject Variables (Data) (< 1 %)
Table Column to Variable (< 1 %)
ARFF Reader (< 1 %)
Database Update (< 1 %)
Database Looping (< 1 %)
Loop End (Column Append) (< 1 %)
Generic Loop Start (< 1 %)
Recursive Loop End (< 1 %)
Recursive Loop Start (2 ports) (< 1 %)
Recursive Loop Start (< 1 %)
Fuzzy Rule Predictor (< 1 %) Streamable
Fuzzy c-Means (< 1 %)
Decision Tree Predictor (< 1 %)
~~K Nearest Neighbor~~ (< 1 %) StreamableDeprecated
MultiLayerPerceptron Predictor (< 1 %) Streamable
~~Regression Predictor~~ (< 1 %) Deprecated
Scorer (< 1 %)
~~Random Forest Predictor~~ (< 1 %) Deprecated
~~Gradient Boosted Trees Predictor~~ (< 1 %) StreamableDeprecated
~~Random Forest Predictor~~ (< 1 %) StreamableDeprecated
Distance Matrix Pair Extractor (< 1 %)
Auto-Binner (Apply) (< 1 %) Streamable
Binner (Dictionary) (< 1 %) Streamable
Cell Splitter By Position (< 1 %) Streamable
Column Auto Type Cast (< 1 %)
Many to One (< 1 %)
Domain Calculator (< 1 %)
Edit Numeric Domain (< 1 %)
Equal Size Sampling (< 1 %)
Missing Value Column Filter (< 1 %)
Nominal Value Row Splitter (< 1 %) Streamable
Denormalizer (< 1 %) Streamable
Denormalizer (PMML) (< 1 %) Streamable
Numeric Row Splitter (< 1 %)
Set Operator (< 1 %)
Target Shuffling (< 1 %)
Rule Engine (Dictionary) (< 1 %) Streamable
Empty Table Switch (< 1 %)
IF Switch (< 1 %)
Extract Table Dimension (< 1 %)
Extract Table Spec (< 1 %)
Merge Variables (< 1 %)
Timer Info (< 1 %)
Box Plot (< 1 %)
Color Appender (< 1 %)
Color Manager (< 1 %)
Molecule Type Cast (< 1 %) Streamable
SDF Stripper (< 1 %)
Parallel Chunk End (< 1 %)
k-Medoids (< 1 %)
Column Expressions (< 1 %) Streamable
Math Formula (Variable) (< 1 %)
SAS7BDAT Reader (< 1 %)
~~XLS Writer~~ (< 1 %) Deprecated
Java IF (Table) (< 1 %)
Java Snippet Row Filter (< 1 %) Streamable
Term Co-Occurrence Counter (< 1 %)
NGram Creator (< 1 %)
Dictionary Filter (< 1 %) Streamable
~~Bag of Words Creator~~ (< 1 %) Deprecated
Bag Of Words Creator (< 1 %)
~~Document Data Extractor~~ (< 1 %) Deprecated
Document Data Extractor (< 1 %)
Sentence Extractor (< 1 %)
~~Strings To Document~~ (< 1 %) StreamableDeprecated
Strings To Document (< 1 %) Streamable
String To Term (< 1 %)
Term To String (< 1 %)
Google Sheets Reader (< 1 %)
Column Filter (< 1 %)
Integer Input (< 1 %)
Line Plot (JavaScript) (< 1 %)
JSON Path (< 1 %) Streamable
Columns to JSON (< 1 %) Streamable
Image Reader (< 1 %)
Image Reader (Table) (< 1 %)
Edge Table (< 1 %)
Call Workflow (Table Based) (< 1 %)
~~Python Script (1⇒1)~~ (< 1 %) Deprecated
~~Python Source~~ (< 1 %) Deprecated
R Snippet (< 1 %)
GET Request (< 1 %) Streamable
Disturber Node (< 1 %)
Date&Time Difference (< 1 %) Streamable
UNIX Timestamp to Date&Time (< 1 %) Streamable
Create Date&Time Range (< 1 %)
Modify Time (< 1 %) Streamable
Date/Time Shift (legacy) (< 1 %)
Date/Time Shift (legacy) (< 1 %)
Date Field Extractor (legacy) (< 1 %)
Date Field Extractor (legacy) (< 1 %)
Time Field Extractor (legacy) (< 1 %)
Extract Time Window (legacy) (< 1 %)
Extract Time Window (legacy) (< 1 %)
Time Generator (legacy) (< 1 %)
Mask Date/Time (legacy) (< 1 %)
Time to String (legacy) (< 1 %) Streamable
XML Reader (< 1 %)
Lhasa Type Caster (< 1 %)
Molecular Properties (< 1 %)
Fingerprint Similarity (< 1 %)
RDKit Interactive Table (< 1 %)
RDKit From Molecule (< 1 %)
Show all 225 recommendations

Workflows

Installation

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

KNIME 3.7

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.