Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • Cell Replacer
NodeNode / Manipulator

Cell Replacer

Manipulation Column Convert & Replace Streamable
Drag & drop
Like
Copy short link

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.

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 node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    2021-01-10_Vlookup function
    charm_myae > Public > 2021-01-10_Vlookup function
  2. Go to item
    2020_03_23_RandomMatcher
    iris > Public > ExamplesForTheForum > 2020_03_23_RandomMatcher
  3. Go to item
    Replacing values within a list_FORUM
    arddashti > Public > Replacing values within a list_FORUM
  4. Go to item
    ReplaceCellValues
    mkoatwork > Public > TricksAndTipps > ReplaceCellValues
  5. Go to item
    Dictionary
    ana_ved > Public > Dictionary
  6. Go to item
    Year Temps Bar chart
    elsamuel > Public > Year Temps Bar chart
  7. Go to item
    02_Data_Merging
    ana_ved > Simple exercises with KNIME > Exercises > Basics > Solutions > 02_Data_Merging
  8. Go to item
    03_Data_Transformation
    ana_ved > Simple exercises with KNIME > Exercises > Basics > Exercises > 03_Data_Transformation
  9. Go to item
    justknimeit-6
    arddashti > Public > justknimeit-6
  10. Go to item
    Init
    Model process Model process factory Enterprise
    This workflow is part of the model factory eco system. Please refer to our white paper fo…
    knime > Examples > 50_Applications > 26_Model_Process_Management > Process > AirBNB > workflows > PricePred > AirBnB_PricePred_01_Init
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits