Group by one column and perform the sum operation for multiple columns

[testing_mail]

Need to Group by one column and perform the sum operation for multiple columns as like below.
Input:

output:

[balupad14 (Balamurugan (BalaReva))]

Hi @testing_mail,

Take a look this one.

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

[testing_mail]

Getting this error while executing.

[balupad14 (Balamurugan (BalaReva))]

can you attach the xmal with sample data ?

Regards
Balamurugan.S

[testing_mail]

Book2.xlsx (10.6 KB) Main.xaml (5.9 KB)

[balupad14 (Balamurugan (BalaReva))]

Hi @testing_mail,

The datatable columns are object type not a native type. I have changed it. .

testing_mail.zip (26.0 KB)

Regards
Balamurugan.S

[kadiravan_kalidoss (Kadiravan K)]

GroupBySum.xaml (11.0 KB) inputSheet.xlsx (8.7 KB)

Thanks!

[testing_mail]

Do i have to add any other package?

[balupad14 (Balamurugan (BalaReva))]

yes I have added the package in the below

Regards
Balamurugan.S

[balupad14 (Balamurugan (BalaReva))]

This is the output …

Regards
Balamurugan.S

[testing_mail]

yeah this works fine now. Thanks.