Using the #FORMAT Mapping Type

  To use the #FORMAT mapping type:

1. Select Workflow, and then under Data Load, select Data Load Mapping.

2. In the Data Load Mapping, in the Dimensions, drop-down, select the dimension name.

3. Select either the Between, In or Like tab.

4. Click Add.

5. In Source Value, enter the segment to map.

   For example, enter: 12345-6789-012-3456ABC-001

6. In the Target Value, select the format map for the target member using this format: #FORMAT(<format mask>, <segment delimiter>).

   For example, enter #FORMAT(“???-*-GROUP-AA##?#*X-GROUP”,”-“)

   For information on the format map components, see #FORMAT Mapping Type Components.

7. To reverse the sign of the target account specified, select Change Sign.

8. Enter the Rule Name.

9. In Description, enter a description of the mapping.

10. Select Apply to Rule to apply the mapping only to a specific data rule in a location.

    For other data rules in the location the mapping are not applied.

    By the default, mappings specified at a location are applicable to all data rules in a location.

11. Click Save.

    The result of applying format map created in steps 5 and 6 is: 123-6789-GROUP-AA5ABCX-GROUP