Skip to main content

Replace Values

1. Overview

This operator can replace a specific value in a dataset column.

2. Usage Guide

2.1. Operation Steps

  1. Drag the Replace Values operator from the ETL operator area to the right canvas editing area;
  2. Click the Replace Values operator and select the column to replace values in;
  3. Configure replacement rules, enter original value → replacement value;
  4. Configure how to write the replacement result as needed (optional):
  • Overwrite the original column
  • Create a new column (user-defined)
  1. Configure how to handle values that do not meet the replacement rule as needed (optional):
  • Use the original value
  • Use a new default value (user-defined)
  1. After all configurations, preview the data result.

image.png

2.2. Detailed Description

Below is an example of replacing values in the Province column, replacing "English Exercise Book Collection" with "6th Grade English Exercise Book Collection" in one click.

  1. Click the Replace Values operator and select the Product Name column for value replacement;
  2. Configure replacement rules: set the original value to "English Exercise Book Collection" and the target value to "6th Grade English Exercise Book Collection";

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

  1. Select the column to replace values in (confirm column);
  2. Set how to write the replacement result (overwrite the original column value or create a new column);
  3. Set how to handle values that do not meet the replacement rule (use the original value or use a default value).

[Possible reasons for value replacement errors in ETL](../../../../12-Error Description.md#etl-value-replacement-error).

Preview before replacement:

Preview after replacement:

image.png

For subsequent use of other data processing operators, see Getting Started.