NodeCell Replacer

Manipulator

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.

Input Ports

  1. Port Type: Data
    Table containing column whose values are to be replaced.
  2. Port Type: Data
    Dictionary table containing two columns: one lookup column and one replacement column.

Output Ports

  1. Port Type: Data
    Input table with replaced target column.

  1. Extracting Minimum and corresponding Index

    Excel Column Names
    This workflow demonstrates how to extract Index (Column Name) after calculating minimum value from selected columns. Two…
    ipazin > 2019_08_14_ExtractingMinimum&IndexFromColumns

  2. Data Mining

    machine learning data mining classification regression prediction model evaluation scoring ROC Curve clustering k-Means decision tree linear regression partitioning education
    Exercise 4 for KNIME User Training - Training a Decision Tree to predict a nominal target column - Evaluate the model pe…
    knime > Education > 01 KNIME User Training > exercises > 04. Data Mining

  3. Neural Machine Translation from English to German: Deployment Workflow

    deep learning keras sequence analysis text analysis text processing machine translation neural machine translation neural language translation lstm encoder decoder neural network sequence to sequence NLP Natural Language Processing
    This is the deployment workflow of the encoder-decoder neural architecture for the Neural machine Translation model. It …
    knime > Examples > 04_Analytics > 14_Deep_Learning > 02_Keras > 12_Machine_Translation > 02_Deploying_a_Neural_Machine_Translation_Model

  4. Generate Text Using a Many-To-One LSTM Network (Training)

    deep learning keras text generation RNN LSTM text analysis sequence analysis neural network text processing
    The workflow builds, trains, and saves an RNN with an LSTM layer to generate new fictive fairy tales. The brown nodes de…
    shima0011 > 04_Analytics > 14_Deep_Learning > 02_Keras > 11_Generate_Fairy_Tales > 01_Training

  5. Generate Mountain Namesn (Training)

    deep learning keras text generation RNN LSTM text analysis sequence analysis neural network text processing
    The workflow builds, trains, and saves an RNN with an LSTM layer to generate new fictive mountain names. The brown nodes…
    shima0011 > 04_Analytics > 14_Deep_Learning > 02_Keras > 10_Generate_Product_Names_With_LSTM > 01_Training

  6. Init

    model process model process factory enterprise
    This workflow is part of the model factory eco system. Please refer to our white paper for further details.
    knime > Examples > 50_Applications > 26_Model_Process_Management > Process > AirBNB > workflows > rentedAppPred > AirBnB_rentAppPred_01_Init

  7. Identify PII and Special Category Data

    GDPR Customer Intelligence Legal Law Privacy
    This example is to show techniques for identifying personal data and special category data. It uses Quickforms and JavaS…
    knime > Examples > 50_Applications > 34_GDPR_examples > 01_Identify_PII_and_Special_Category_Data

  8. Update the update_Type for the modelling configurations

    model process model process factory enterprise
    This workflow is part of the model factory eco system. Please refer to our white paper for further details. This workflo…
    knime > Examples > 50_Applications > 26_Model_Process_Management > helperWorkflows > Webportal_Update_Type_Change

  9. Guided Visualization and Exploration

    guided visualization guided analytics guided exploration machine learning automation JavaScript interactive view customization data type conversion nested wrapped metanode KNIME WebPortal CSS data scientist business analyst
    Guided exploration provides a data scientist with insights into data at hand. Any dataset can be used. The data are auto…
    knime > Examples > 50_Applications > 54_Guided_Visualization_and_Exploration > 01_Guided_Visualization_and_Exploration > 03_Guided_Visualization_and_Exploration

  10. Data Mining - Solution

    machine learning data mining classification regression prediction model evaluation scoring ROC Curve clustering k-Means decision tree linear regression partitioning education
    Exercise 4 for KNIME User Training - Training a Decision Tree to predict a nominal target column - Evaluate the model pe…
    knime > Education > 01 KNIME User Training > solutions > 04. Data Mining - solution