Skip to content

Aggregate

Use the Aggregate node to take separate items, or portions of them, and group them together into individual items.

Node parameters

  • Aggregate: choose whether to aggregate Individual Fields or All Item Data.
  • If you choose Individual Fields, you can then configure the fields you want to aggregate with the following parameters:
    • Input Field Name: the name of the field in the input data to be aggregated together.
    • Rename Field: enable this toggle to enter a field name for the aggregated output data. When aggregating multiple fields you must provide new output field names. You can't leave multiple fields undefined.
    • Output Field Name: displayed when you enable Rename Field. The field name for the aggregated output data.
    • Options > Add Field: use this to add more optional settings, including:
      • Disable Dot Notation: when disabled, you can't reference child fields (in the format parent.child).
      • Merge Lists: enable this if the field to aggregate is a list, and you want to output a single flat list rather than a list of lists.
      • Include Binaries: include binary data from the input in the new output.
      • Keep Missing And Null Values: enable this to add a null (empty) entry in the output list when there is a null or missing value in the input.
  • If you choose All Item Data, you can then set:
    • Put Output in Field: the name of the output field.
    • Include: choose from All fields, Specified Fields, or All Fields Except.
    • Options > Add Field: use this to add the setting:
      • Include Binaries: include binary data from the input in the new output.

Learn more about data structure and data flow in Mosaic Workflows workflows.