UiPath Documentation
maestro
latest
false
Maestro Orchestrate user guide

Group by

Group the entries of a list by a shared field, and compute totals, averages, or counts for each group.

Groups a collection by a shared field and aggregates values like totals, averages, or counts.

Configuration​

FieldRequiredDescription
InputYesThe collection (array) to group.
Group by fieldYesThe field whose value determines the group.
AggregationsNoAdditional computed fields per group (count, sum, average, min, max, first, last, collect).

Example​

Group a list of orders by region and count the number of orders per region:

  • Input: $vars.fetchOrders1.output.body
  • Group by: region
  • Aggregation: orderCount = count

Output available as $vars.groupBy1.output.

Next steps​

  • Transform: chain several operations in one node.
  • Script: custom logic when no data operation fits.
  • Configuration​
  • Example​
  • Next steps​

Was this page helpful?

Connect

Need help? Support

Want to learn? UiPath Academy

Have questions? UiPath Forum

Stay updated