Using Special Characters in Multi-Dimensional Mapping

The Source and Target Value expressions can have the asterisk special character. An asterisk (*) represents the source value. The asterisk (*) can be prefixed or suffixed by one or more characters, which filters the source value by that prefix or suffix. The wild card or strips (write back only) takes whatever is present in the source and puts it in the target column, usually adding a prefix.

Table 23. Using the * Special Character in Like and Multi-Dimensional Mapping Types

TypeSource ValueMap SourceMap TargetResult
LikeE1000 E**1000
LikeE1000 E*F*F1000
MDE1000 E**E1000
MDE1000 E*F*FE1000