If the Hierarchy Processor transformation output contains an array, you might want to add an output field to aggregate values in the array. The output field must be a sibling of the array field.
For example, the Output group contains an array with orders information. The Orders array contains the OrderPrice field, which stores the price for each order. You want to find the total order price for each company.
The following image shows the output fields:
To find the total order price, add a field called TotalOrderPrice to the output group.
Edit the TotalOrderPrice field. Select
Use this field to aggregate values in an output field array
, and select the Orders array as the output field for which you want to aggregate values. Configure the following expression for the TotalOrderPrice field: