Sum values with same client code

[Gagi77 (Dragan)]

Hello guys and girls,

Again, i need help from you.
In data table i have 3 columns

I need to Robot sum values by client code (sum for MP001, sum for MP002).

Thank you advance to all of you

Regards,

[Palaniyappan (Palaniyappan P)]

kindly have a view on this thread

How do I group by one column in the datatable and take the sum?

@jamnanin I will suggest you one more way try like this. Let us take your excel stored in a datatable dta First group the datatable based on ID by using below Query and assign it to dt1 dt1=(From p In dta.Select() Group p by ID=p.Item(“ID”).ToString Into Group Select Group(0)).ToArray.CopyToDataTable() Now take only two columns by using below query dt1=dt1.DefaultView.ToTable(False,“ID”,“Name”) Now Add one datacolumn to dt1 by using add datacolumn activity and give name Amount to that c…

Cheers @Gagi77

[Gagi77 (Dragan)]

@Palaniyappan thanks buddy, is done