How to aggregate data in datatable using LINQ in uipath(Group by Operator)

[Manoj_Batra (Mannoj Batra)]

Problem statement : We have a datatable that contains the order details for all customers and the ask here is to fetch the the total sales for each region.

This is the sample data and we need to group date based on the ‘Region’ Column

Drag the assign activity to the workflow, write the following query

Run the program and see the magic

Youtube Video: Group By records in a Datatable Using Linq in Uipath - YouTube

Code: UiPathSamples/08 - GroupByUsingLinq at main · manojbatra071/UiPathSamples · GitHub

Medium: How to aggregate data in datatable using LINQ in uipath(Group by Operator) - Manoj Batra - Medium

Happy Automation