Concatenate
Logic name
Concatenate (Document Mapper/Variable Mapper/Merge Mapper)
Function
This logic concatenates multiple input strings and returns the result.
Data types
|
Location |
Type |
|---|---|
|
First input handler |
String |
|
Second input handler |
String |
|
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 |
Input count |
Specify the number of input items as 2 or more. |
|
Null processing |
Null option |
Specify how to handle the input if it contains null. |
|
Comment |
Comment |
You can write a description of the logic. It doesn't affect the conversion process. |
Null option
|
Option |
Description |
|---|---|
|
Determine/calculate while remaining null value |
Outputs null if all the values of input handlers are null, otherwise excludes the null values and continues with the process. |
|
Output null if either of input handler is null |
Outputs null if the value of any input handler is null. |
Refer to the following for details:
-
Logic specifications (Document Mapper/Variable Mapper)
-
Logic specifications (Merge Mapper)
Function details
About input count
You need enter a number greater than or equal to "2" in Input count. The number of input handlers varies depending on the value of Input count.
The recommended maximum value of Input count is "100". To consolidate over 100 strings, use several Concatenate logics.
Logic sample
Mapping definition
Logic settings and processing result
The logic joins the first column "Hello", the second column " " and the third column "World!" of the input data, and outputs data.
Property settings
|
Property |
Setting |
|---|---|
|
Input count |
3 |
Input data
|
Hello, ,World! |
Output data
|
Hello World! |
For a list of logics, refer to Mapper Logic Guide.