Sum value base on value at another column on datatable

[Mr.H]

Hi Everyone.

I have a datatable as excel file.

I want to sum “Amount” column base on same value at “ID” column and return result into C column.

How to do that ?

Thanks in advance!
Book1.xlsx (8.2 KB)

[tavineei (Tav)]

Hi,
If you want to group by and sum, you can use ‘Group By Aggregation’ activity (Download Package: BalaReva.DataTable.Activities).
This return the result as key and sum value.

[ppr (Peter)]

@Mr.H
find starter help here:
GroupBy_Sum_1Col.xaml (7.9 KB)
GroupBy_Sum_1Col_SumColAdded.xaml (7.7 KB)

[Mr.H]

Thanks you all of you!