Linq Query, Please Help!

Learning Initatives Reboot Your Skills 2021
2

@kantheshm

give a try on following

prepare an empty datatable with build datatable reflecting the target datacolumn strucutre:
Col1 – Col2 - Col3 Variable: dtResult

then use an assign activity
left side: dtResult
right side:
(From d in dtData.AsEnumerable
Group d by k1=d(“Col3”).toString.Trim,k2=d(“Col4”).toString.Trim into grp=Group
Let s = grp.Sum(Function (x) CInt(x(“Col2”).toString.Trim))
Ler ra = new Object(){k1,s,k2}
Select dtResult.Rows.Add(ra)).CopyToDataTable

Also have a look here:

2 Likes