Aggregate Node

Aggregate multiple items into a single item with combined values.

Written By pvdyck

Last updated 16 minutes ago

The Aggregate node combines multiple input items into a single output item. Useful for collecting all results before passing them downstream.

Operations

Operation	Description
Individual Fields	Collect values of specific fields across all items into arrays. You choose which fields to aggregate and what to name the output arrays
All Item Data	Combine all item data into a single list under one field

Parameter	Description
Input Field Name	The field to collect values from across all items
Output Field Name	The name of the output array field (renamed from input)

You can add multiple field aggregations in a single node.

Parameter	Description
Put Output in Field	The field name that will contain the array of all items
Include	Choose to include All Fields or Specified Fields

Option	Description
Merge Lists	When aggregating fields that are already arrays, merge them into a flat list instead of nested arrays
Keep Missing And Null Values	Include `null` or missing values in the aggregated output instead of skipping them
Include Binary	Preserve binary data from the input items
Disable Dot Notation	Treat dots in field names as literal characters

Three input items with {name: "A"}, {name: "B"}, {name: "C"} become one item: {names: ["A", "B", "C"]}.