Administration Guide › Mapping and Parsing › How to Create a Data Mapping File › Set Concat Function Mapping

Previous Topic: Set Function Mappings

Next Topic: Set Conditional Mappings

Set Concat Function Mapping

A Concat function mapping is a type of function mapping. Unlike other function mappings, which specify one target field or value, the concat function specifies multiple mapping targets, which it concatenates into one CEG field.

You can use the Data Mapping wizard to create concat function mappings. Because concat mappings are different from other function mappings, the procedure for creating them is somewhat different.

To set a concat function mapping

  1. Open the mapping file wizard, enter a name and select a Logname for the mapping file, and advance to the Function Mappings step.

    The Function Mappings screen appears, displaying current or default mappings. The Name column shows a CEG field, the Function column the current linking function, and the Value column a text or field value.

  2. Click Add Function Mapping to add a new mapping entry.

    The mapping entry appears in the Mapping Details pane.

  3. Select a CEG field to map to from the Field drop-down menu.
  4. Select the concat function from the Function drop-down menu.

    The Format and Value fields appear.

    Note: The value for the concat function is displayed as {…} in the Function Mappings pane. This means that there is a set of values instead of one value.

  5. (Optional) Enter a specifier in the Format field to control the placement of the target fields. The format specifier, %s, indicates a field position. Anything other than %s is considered static supporting data to be included in the final table collector field. For example, to separate two target fields with a colon, enter "%s:%s" in the Format field.
  6. Click Add Concat Value in the Concat Values area to add a target input/value pair.
  7. Enter a value in the Add value entry field, and click Add Value.

    The value appears in the Selected Fields area.

  8. Repeat steps 6 and 7 to add additional values to concatenate. You must add at least two target values.
  9. When you have added all the concat mappings you want, click the appropriate arrow to advance to the wizard step you want to complete next, or click Save and Close.

    If you click Save and Close, the new file appears in the Mapping File User folder, otherwise the step you choose appears.