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