Adding an aggregate mapping

An aggregate mapping maps multiple instances on the source side to a non-repeatable (scalar) target for some form of aggregation, such as summation. The following steps show you how to create an aggregate mapping.

  1. Create a single aggregate mapping from an [All] node on the source side to a non-repeatable target using the drag-and-drop method. This is a single operation that is effective for all created instances at the source. A single one-to-one mapping is created, looping over all the repeating items in the source message, to the cardinality of the input.
  2. In the Message Flow Mapping editor Overview, click the Target Value that you want to edit and then click the box that appears on the right side of this value. The Compose Mapping Expression editor appears, showing the loop.
  3. Use the editor to provide the required information about the mapping. For example, you can specify whether the source values are concatenated or added.
  4. Click OK to close the Compose Mapping Expression editor.
  5. Save the mapping resource.
Related concepts
Repeating mappings
Aggregate mapping and unknown numbers of instances
Related tasks
Adding instances in repeating structures
Removing instances in repeating structures
Adding a repeating mapping
Adding a repeat-to-repeat throughput mapping
Adding a looped assignment mapping
Adding a one-sided looped assignment mapping
Related reference
Mappings