Replace Null/Empty String
Logic name
Replace Null/Empty String (Document Mapper/Variable Mapper/Merge Mapper)
Function
This logic replaces the input value to the specified value (number) when it is null or an empty string.
Data types
|
Location |
Type |
|---|---|
|
First input handler |
Numeric |
|
Logic output |
Numeric |
Refer to the following for details:
-
Logic specifications (Document Mapper/Variable Mapper)
-
Logic specifications (Merge Mapper)
Properties
|
Category |
Property |
Description |
|---|---|---|
|
Required settings |
Convert null |
Specify whether to convert null. |
|
Required settings |
Convert empty string |
Specify whether to convert an empty string. |
|
Required settings |
Specified value |
The input value will be replaced with the specified string when it is null or an empty string. |
|
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 logic replaces the value of input data to "100" when it is null or an empty string.
Property settings
|
Property |
Setting |
|---|---|
|
Convert null |
Selected |
|
Convert empty string |
Selected |
|
Specified value |
100 |
Input data
|
Data,1 |
|
null value,(null value) |
|
empty string,(empty string) |
Output data
|
1 |
|
100 |
|
100 |
For a list of logics, refer to Mapper Logic Guide.