Creating Write-Back Mappings

To create write-back mappings:

  1. On the Workflow tab, under Data Load, select Data Load Rule.
  2. Enter the Location Name or click Search button to navigate and select the location.
  3. Select the Segment.
  4. Choose the type of mapping by selecting one of the following tabs: Explicit tab, Between tab, In Multi-Dimension, or Like tab.
    • Explicit—The source value is matched exactly and replaced with the target value. For example, the source value, "ABC" is replaced with the target value, "123". "Explicit" write-back mappings are created the same for data load and data load to write back rules. See Creating Mappings Using the Explicit Method.

    • Between—The range of source values is replaced with a single target value. For example, a range from 001 to 010 is replaced with 999. "Between" write-back mappings are created the same for data load and data load to write back rules. See Creating Mappings Using the Between Method.

    • In—In mappings enable a list of non-sequential source values to be mapped to one target value. In this case, multiple values are mapped to one value within one rule, eliminating the need to create multiple rules (as is required for an Explicit map).

    • Multi-Dimension—Define member mapping based on multiple source column values.

    • Like—The string in the source value is matched and replaced with the target value. For example, source value Department is replaced by Cost Center A. See Creating Mappings Using the Like Method.

      Write-back mappings provide a means to remove or strip characters that were added during the data load process. "Like" write-back mappings are created like a reverse data load.

    Tip:

    You can click Refresh Values to refresh the list of segments or chartfield values that appear in the drop-down list from the source system. This is especially helpful when creating "Explicit", "Between", "Like", and "Multi-Dimension" mappings for data load rules to write back.