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. Select the format map for the target member using the #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 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.