Skip to main content

Value Mapper

Overview

This operator can replace specific values in a dataset.

User Guide

Steps

  1. Drag the Value Mapper operator from the ETL operator area to the canvas on the right.

  2. Click the Value Mapper operator and choose the column where values need to be replaced.

  3. Configure replacement rules by entering Original Value -> Replacement Value.

  4. Optionally configure How Replacement Results Are Written:

    • Overwrite the original value column
    • Create a new column, which must be defined by the user

  5. Optionally configure how to handle Values That Do Not Match Replacement Rules:

    • Use the original value
    • Use a new default value, which must be defined by the user

  6. After everything is configured as needed, preview the data result and publish.

Detailed Explanation

The following example uses value replacement in the Product Name column and changes Chocolate Milk Tea to Chocolate Milk.

  1. Click the Value Mapper operator and choose Product Name as the target column.

  2. In Configure Replacement Rules, set the original value to Complete English Exercise Book Collection and the target value to Grade 6 Complete English Exercise Book Collection.

In real business scenarios, if a store name changes, the related store information table must also be updated. In this case, batch data replacement can help users complete the update efficiently.

  1. Select the target column to Value Mapper in.

  2. Set how the replacement results are written: overwrite the original column or create a new column.

  3. Configure how values that do not match the replacement rules are handled: use the original value or use a default value.

    |300

What are the possible causes of errors when using Value Mapper in ETL?

For other data processing operators used later, see Getting Started.