Updated on 2024-07-19 GMT+08:00

Null Value Conversion

Overview

The null value conversion operator replaces null values with specified values.

Input and Output

  • Input: fields with null values
  • Output: original fields with new values

Parameter Description

Table 1 Operator parameters description

Parameter

Description

Node Type

Mandatory

Default Value

Input field name

Names of fields that may have null values. Set this parameter to the names of existing fields.

string

Yes

None

Replace by this value

Specified values for replacing null values.

string

Yes

None

Data Processing Rule

When field values are empty, specified values are added.

Example

Use the CSV File Input operator to generate two fields A and B.

The following figure shows the source file.

Configure the null value conversion operator, as shown in the following figure.

After replacement, the values of fields A and B are as follows: