Hub
Pricing About
NodeNode / Manipulator

Cell Replacer (deprecated)

ManipulationColumnConvert & ReplaceStreamable

This node has been deprecated and its use is not recommended. Please search for updated nodes instead.

Like

(This node has been superseded by the "Value Lookup" node.)

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 and an output column that contains the corresponting replacement. 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.

When the lookup column is of type String, it's also possible to replace the cell if

  • The lookup string is a only a substring of the target cell. Example: Match the lookup string "John" to the cell "Johnny".
  • The lookup string is a Wildcard expression that matches the target cell where `*` to represents zero or more arbitrary characters and `?` represents a single optional character. Example: Match "A*z" to all proper nouns starting and ending with "a", like e.g. "America", "Australia" or "Alabama".
  • The lookup string is a Regular Expression that matches the target cell. Example: Match "^[knime]+$" to all words containing only the letters "k", "n", "i", "m" and "e", like e.g. "knee" or "mine".

Note that the Substring, Wildcard and RegEx methods bring a significant performance penalty, since every target cell must be checked against every lookup cell.

When matching with strings, it is possible to match either case-sensitively or ignore case.

Instead of replacing the target column, the column containing the replacements can be appended instead. Furthermore, a column indicating whether the value was found (and therefore replaced) can be appended.

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.

Node details

Input ports
  1. Type: Table
    Input Table
    Table containing column whose values are to be replaced.
  2. Type: Table
    Dictionary Table
    Dictionary table containing two columns: one lookup column and one replacement column.
Output ports
  1. Type: Table
    Table with replaced column
    Input table with replaced target column.

Extension

The Cell Replacer (deprecated) node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
  2. Go to item
  3. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits