Replace Null

Logic Name

Replace Null

Function

Replaces the input value with the specified string when it is null.

Data Types

Location Type
The first input handler Data (including null)
Logic output String
lightbulbRefer to "Logic Specifications" for details.

Properties

Category Property Description
Required Replacement string The input value will be replaced with the specified string when it is null.
Comment Comment The comment will also be output to the specifications.It does not affect the conversion process.

Logic Sample

Mapping Definition

Logic Settings and Processing Result

The following shows the mapping example to insert string "Unclassified" when the value of column "Category" is empty(null) in input data, and output the value itself if it is not empty(null).
Property Settings
Property Setting
Replacement string Unclassified
Input Data
Database,Sample1
,Sample2
Application,Sample3
Result Data
Database,Sample1
Unclassified,Sample32
Application,Sample3