To combine two or more data values in your data set, use the || operator. The operator combines the data values that you require into a single string.
For example, your organization might combine values to generate unique identifiers or keys. You might concatenate relevant attributes in your data set, such as a customer ID and an order ID to create a composite key that ensures unique identification of a data value.
1Open a rule specification in advanced mode.
2Verify that the rule specification contains the inputs and outputs that you require.
- If the rule specification does not contain an input and an output that you can use, create an input and output. Configure the input and output properties to represent the type of column that contains the business data.
3In the rule editor, type the IF element of the IF-THEN-ELSE statement.
4To specify the input, type the input name.
5Enter the input value. For example, enter 12345.
6Enter an operator value. For example, enter the AND value to connect the inputs.
7To specify another input, type the input name.
8Enter the input value. For example, enter 1111.
9Type the THEN element.
10To specify the output, type the output name.
11Enter an operator value. For example, enter the = value to write a value for the data that satisfies the rule logic.
12Enter the input names and use the || operator between the inputs to combine the values in the inputs.
13Type the ENDIF element.
The following example shows the use of concatenate operator:
IF (Input = "12345" AND Input1 = "1111") THEN Output = (Input || Input1) ENDIF