Using Special Characters in the Target Value Expression

You can use only an asterisk (*) in the target expression, and you can prefix or suffix any number of characters to the asterisk (*) character. When you run the rule, the asterisk (*) is replaced by the resulting source value (which may or may not have its own source expression), and is concatenated to any prefix or suffix that you have specified in the target expression. For example:

Target Value:

A*

Result:

1000 = A1000

Target Value:

*_DUP

Result:

1000 = 1000_DUP

Note:

<BLANK> is supported in the target value expression in data mappings and can be used in all mapping types (Like, Between, Explicit, and Multi-dimension). When writing data to an Enterprise Resource Planning (ERP) GL interface table, the <BLANK> notation may be used for a target dimension mapping to successfully pass the validation step in the workflow process. For example, when writing back to the Peoplesoft journal interface table, the specification of <BLANK> can be used when the user does not want to provide a value for a chart field value, but needs to successfully validate the write-back data.