Group Datatable

[Betul_Dundar (Betül Dündar)]

Hi All!

I have a datatable like this. I want to group by “Column1” adding values “Column2”
→

Excel is here
Datatable.xlsx (9.4 KB)

[mkankatala (Mahesh Kankatala)]

Hi @Betul_Dundar

What is your required output, Share an image or file.

[Betul_Dundar (Betül Dündar)]

File is added. in Sheet2 expected output

[Yoichi]

Hi,

How about the following sample?

dt.AsEnumerable.GroupBy(Function(r) r(0).ToString).Select(Function(g) dt.Clone.LoadDataRow({g.Key,g.Sum(Function(r) Double.Parse(r(1).ToString,System.Globalization.NumberStyles.Any,new System.Globalization.CultureInfo("es-ES"))).ToString("#,0.###",new system.Globalization.CultureInfo("es-ES")),g.First.item(2),g.First.item(3),g.First.item(4)},False)).CopyToDataTable

Sample
Sample20240125-8a.zip (9.7 KB)

Regards,

[Betul_Dundar (Betül Dündar)]

Thank you! It worked!!!