How to Sum and Group By multiple rows data from LINQ in Uipath

Pls share xaml file

Same result;

(From r In DtSheet6.AsEnumerable
Group r By Emp = r.Field(Of String)("Emp") , Dept = r.Field(Of String)("Dept") Into grpvar =Group
Let sumvalue = grpvar.Sum(Function(s) CDbl(s("Wh")))
Let inputarr = New Object(){Emp,Dept,sumvalue}.ToArray()
Select DtResult3.Rows.Add(inputarr)).CopyToDataTable

thank you so much

Could you please send Query syntax for this LINQ

Hi, what is the Variable Type for strResult?

please provide details of this query and also explain how to do this without linq query.

Hi! Firstly Thank you for your solution. When I try it I am getting an error at strResult. Assign: "Index was outside the bounds of the array" what do you think this error ? (I have 11.000 rows in excel)

please provide details of this query and also explain how to do this without linq query.

Simply awesome...

Thanks for this video brother

How can I change those headers name?

Detailed analysis - for each LINQ video is required

Hi, you should explain the different components used in the process first, afterwards when you are explaining linq, you should explain meaning behind each word. Continue the good work.

Facing an error. It says "Input string was not in a correct format." in Assign Activity of IEnum variable.
(From p In dtSheet1.AsEnumerable() Group p By obj_p= New With {Key.P_Amazon=p.Item("Amazon"),Key.P_Description=p.Item("Description")} Into MG= Group Select New With { .Amazon=obj_p.P_Amazon,.Description=obj_p.P_Description,.Count=MG.Sum(Function( r ) Double.Parse(r.Item("Count").ToString()))}).ToList


Kindly help me with this. Thank you.

Is it possible to share the xaml file pls ?

Its very Amazing Tutorial ,Is it possible to share the meaning of each word which used by you in Qurey .So it will be easy in future for us writing the similar kind of query.

I also wants to learn Linq queries tell me the solution