Value Mapper

Overview

This operator replaces a specific value in a dataset.

Procedure

1. Drag the Value Mapper operator from the dataflow operator panel into the canvas on the right.

   

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

   

3. Configure the replacement rule by entering Original Value -> Replacement Value.

   

4. Configure how replacement results are written as needed:

   • Overwrite the original column
   • Create a new column, which must be named manually

5. Configure values that do not match the replacement rule as needed:

   • Keep the original value
   • Use a new default value, which must be defined manually

6. After all configuration is complete, preview the result.

Example

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.