Sum values group by columns

excel

#1

Hi guys,
I have just started work with UIPath and have some issues.
can you please help me to understand how to develop the follow code in UI Path for DataTable:
select client_number, Currency, Start_Date, End_Date, sum(Amount) as sum_amount, sum(Commision) as commision
group by client_number, Currency, Start_Date, End_Date
The excel example is attached.
Thank you very much in advance!
DimaUntitled.xlsx (10.8 KB)


#2

Hi @Stelz,

Refer this

Regards,
Arivu


#3

HI @Stelz,
It may help you.

Regards
Balamurugan.S


Sum of all Repeated values in Excel
#4

Thank you very much. It works. Sorry for late reply