aggregation buckets to flat array

This block is part of the array group and was last modified in core v9.3.5.

aggregation buckets to flat array v9.2.15 Updated v9.3.5

Converts aggregation buckets to a flat array of objects.

In pins 1
  • Array required
    array

    The array containing aggregation buckets.

Out pins 2
  • Flat
    array

    A flat array of objects obtained from aggregation buckets.

  • Transpose v9.3.5
    array

    A transposed array of objects obtained from aggregation buckets.

Recursively walks nested aggregation buckets starting from ONLY the first input element and emits one flat object per leaf bucket, carrying each level's key and doc_count under aggregation-name-prefixed fields plus a joined unique_key. The transpose output aggregates leaf metrics per first-level key (summing count and sum, tracking min and max, rounded avg), sorted by group. Both outputs are empty when the input is empty or its first element is not an object.

A typical wiring for aggregation buckets to flat array: the array out pin feeds length.

Studio canvas example for the aggregation buckets to flat array block: typical wiring for aggregation buckets to flat array.

Version history

Introduced in v9.2.15.

Last modified in v9.3.5.


Back to array Return to the main group to view all sub-groups Back to array Return to the group to view all blocks within this group