Want to sum data from excel

[ashishmani (ashish mani tripathi)]

i want to add all L6121 ,whose coreponding value is in NET BBLS
and L6511

[ashishmani (ashish mani tripathi)]

sort_Excel.zip (655 Bytes)
here is the excel file

[kadiravan_kalidoss (Kadiravan K)]

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…

Please refer this…!

Thanks!

[parasmanichauhan]

@ashishmani - you can build a datatable as a result of Read Range activity.
and then filter the datatable with L6121 and L6511 values (keeping only NET BBLS column) and then sum up all the values.

Let me know if you need more help.

[ashishmani (ashish mani tripathi)]

can u make xaml for clear explaintion

[ashishmani (ashish mani tripathi)]

plzz explain more

[Luis261980 (Luis Nunes)]

Hi ashishmani,

Probably there are other ideas but i will do it like

If row(3).equals(“L6121”)
Then
Sum
Else
If row(3).equals(“L6511”)
Then
Sum

[kadiravan_kalidoss (Kadiravan K)]

GroupByColumnSumUp.zip (3.1 KB)

Thanks!

[balupad14 (Balamurugan)]

Hi @ashishmani,

Take a look this thread. It may help you.

UiPath Go ! Datatable Activities

Hi All, I have added a new activity in this package called Native Group Aggregation. Here I have attached the Video and Sample Project Also. Using this activity . can able to do Sum,Max,Min and Count in a single activity. Video : [BalaReva DataTable Native Aggregation Group] Sample : DataTableAggregation.zip (25.9 KB) [image] Thank you Balamurugan.S Thank you Balamurugan.S

Regards
Balamurugan.S

[ashishmani (ashish mani tripathi)]

thanks… its working…

[ashishmani (ashish mani tripathi)]

thanks. helpfull activity…