UiPath Documentation
maestro-automate
latest
false
Maestro Automate 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.
  • Community: ask questions and share workflows with other builders on the UiPath Forum.
  • Configuration​
  • Example​
  • Next steps​

Was this page helpful?

Connect

Need help? Support(opens in new window)

Want to learn? UiPath Academy(opens in new window)

Have questions? UiPath Forum(opens in new window)

Stay updated