Rules may specify derivations of concatenated String values of attributes or fixed values. String concatenation functionality may be used for single value and multivalue derivation rules.
- Choose Derivation Rule, select the attribute, check expression, and conditions (see Derivation Rule).
Choose Multivalue Derivation Rule (see Multivalue Derivation Rule) and add a deriving attribute that has a character String data type
2. For Derivation Rule: When condition is TRUE (or FALSE), select the Attribute radio button. Then click the Formula Table button.
For Multivalue Derivation Rule, click the Formula Table button for the deriving attribute in the selected row.
3. In the Formula Table, the type is selected as String Concatenation. Click to add as many rows as required.
4. Enter any number of characters as a delimiter that will be used between the value generated from each row (optional). Spaces or a combination of other characters and spaces are valid.
5. Enter Entity/Attribute and/or Fixed Values in each row. Click Preview to see a preview of the result.
6. Save the Formula Table and finish creating and saving your rule.
Derivation Rule with String Concatenation Example
1. Create a rule to derive NAMELAST – Last name.
This rule has two conditions:
AD_NAME_P – NAMEFIRST = “John”
AD_NAME_P – NAMELAST = “Jingle”
2. Under When condition is TRUE, choose the Attribute radio button and click the Formula Table button.
3. Add two rows to the formula table. Enter Entity/Attribute and Fixed Values. Click Preview to see the result.
4. According to the rule, “John Jingle” derives to “John Jingleheimer Schmidt”
5. Save the Formula Table.
6. Complete any other desired aspects of the rule and save.