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

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

output:
image

1 Like

Hi @testing_mail,

Take a look this one.

Regards
Balamurugan.S

Getting this error while executing.

1 Like

can you attach the xmal with sample data ?

Regards
Balamurugan.S

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

1 Like

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

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

Thanks!

Do i have to add any other package?

yes I have added the package in the below

Regards
Balamurugan.S

This is the output …

image

Regards
Balamurugan.S

yeah this works fine now. Thanks.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.