Using the #FORMAT Mapping Type

  To use the #FORMAT mapping type:

1. On the Workflow tab, under Data Load, select Data Load Mapping.

2. In Dimensions, select the dimension name.

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

4. Click Add.

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

   For example, on the Like tab, enter: 12345-6789-012-3456ABC-001 in the Source Value field.

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”,”-“).

   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.

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

11. Click Save.

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