Sum and group by datatable

Help Studio
, , ,
1

Hi,
i have this table
|Field1|Field 2|Tot|
|A|xx|10|
|A|xx|20|
|B|yy|50|

and i want to obtain this:
|Field1|Field 2|Tot|
|A|xx|30|
|B|yy|50|

i used this and it works, but i want to insert Field 2 in the output, how can i do?

(From d In dtOut.AsEnumerable
Group d By k=d(“Field1”).toString.trim Into grp=Group
Let ra = New Object(){k,grp.Sum(Function (x) Convert.ToDouble(x(“Tot”).toString.Trim))}
Select dtResult.Rows.Add(ra)).CopyToDataTable

2

dtResult = dtOut.Clone

dtResult =

(From d In dtOut.AsEnumerable
Group d By k=d(“Field1”).toString.trim Into grp=Group
Let s = grp.Sum(Function (x) Convert.ToDouble(x(“Tot”).toString.Trim))
Let ra = New Object(){k,grp.First()(“Field 2”),s}
Select dtResult.Rows.Add(ra)).CopyToDataTable

Maybe you want also to group on 2 cols: Field 1, Field 2. But this cannot be derrived from the generic samples and needs to be checked by yourself.