Skip to main content

Array to Single Value

When the input is an array and the target output is a single value, the data mapper offers two options depending on whether you want one element from the array or a value computed across the array.

Extract single element

To pull a single value out of an array, use Extract Single Element. This option appears whenever you map an array onto a single-value output (a dimension mismatch).

Extract Single Element option appearing on a single-value output mapped from an array

Aggregate and map

To compute a single value from each element of an array (for example, sum, average, count), use Aggregate and Map. Aggregation supports primitive-type arrays mapped to a compatible primitive output. The data mapper opens a focused view and prompts for the aggregation operation.

Aggregate and Map focused view with the available aggregation operations

What's next