In DataTable find equals rows and unify them and sum values of one column

[Sudharsan_Ka]

Hi @amy93amanda

Checkout this threads

How to use group by and get sum?

Hi @aapostol Welcome to the community. Follow below steps: Store your input data in a data table called dt1 Create one more datable called dt2 where can store output. Build this data table with two columns namely STORE CODE, TOTAL Now use below linq (From row in dt1.AsEnumerable Group row by sc = row(“STORE CODE”).ToString() Let total= grp.sum(Function (x) Convert.ToDouble(x(“CREDIT”).ToString().Replace(“$”,“”).Trim())) Let result = New-Object() {grp(0)(“STORE CODE”),total} Select dt2.r…

UiPath | LINQ Sum Function | Group Sum LINQ | Get Column Sum | Get Group Sum of Column with LINQ

Sum up the rows of selected column using Select and Group By | Linq query in UiPath - Part 7

Regards
Sudharsan