Replace Null
Logic name
Replace Null (Document Mapper/Variable Mapper/Merge Mapper)
Function
This logic replaces the input value with the specified string when it is null.
Data types
|
Location |
Type |
|---|---|
|
First input handler |
Data (including null) |
|
Logic output |
String |
Refer to the following for details:
-
Logic specifications (Document Mapper/Variable Mapper)
-
Logic specifications (Merge Mapper)
Properties
|
Category |
Property |
Description |
|---|---|---|
|
Required settings |
Replacement string |
The input value will be replaced with the specified string when it is null. |
|
Comment |
Comment |
You can write a description of the logic. It doesn't 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 null, and output the value itself if it isn't null.
Property settings
|
Property |
Setting |
|---|---|
|
Replacement string |
Unclassified |
Input data
|
Database,Sample1 |
|
,Sample2 |
|
Application,Sample3 |
Output data
|
Database,Sample1 |
|
Unclassified,Sample2 |
|
Application,Sample3 |
For a list of logics, refer to Mapper Logic Guide.