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

[amy93amanda (amanda)]

for example in this dt

unify rows that are the same like columna1 1.1 values and columna2 123 and SUM col3 “cantidad”

so the result should be

how to do it?

[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

[supermanPunch (Arpan)]

Hi @amy93amanda ,

There are many posts in here, which provides the relevant solution to your requirement as it is a Group By and Sum case. One of the posts is mentioned below :

Sum and group by datatable

dtResult = dtOut.Clone dtResult = (From d In dtOut.AsEnumerable Group d By k=d(“Field1”).toString.trim Into grp=Group Let s = grp.Sum(Function (x) Convert.ToDouble(x(“Tot”).toString.Trim)) Let ra = New Object(){k,grp.First()(“Field 2”),s} Select dtResult.Rows.Add(ra)).CopyToDataTable Maybe you want also to group on 2 cols: Field 1, Field 2. But this cannot be derrived from the generic samples and needs to be checked by yourself.

Also, Find below Detailed methods on Grouping :

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…

[vishal.kp (vishal)]

Hi @amy93amanda,

Use the below expression in assign activity:

(From d In Dt.AsEnumerable Group d By k=d(“Columna1”).toString.Trim Into grp=Group Let sumVal= grp.Sum(Function (x) CDbl(x(“Cantidad”).toString)) let rows=grp.FirstOrDefault Let ra = New Object(){k, rows(“Columna2”).tostring, sumVal} Select Dt.Rows.Add(ra)).CopyToDataTable

[Manish540 (Manish Shettigar)]

Hi @amy93amanda ,

First create a dt_Grouped datatable variable and clone with input table as below in assign,
dt_Grouped = dt_Input.Clone()

Then in second assign use below linq,

dt_Grouped = (From row in dt_Input.AsEnumerable
Group row by k=row("Columna1").ToString.Trim Into grp=Group
Let total= grp.Sum(Function(x) CDBl(x("Cantidad").ToString.Trim)).ToString
Let result = New Object(){grp(0)("Columna1").ToString,grp(0)("Columna2").ToString,total}
Select dt_Grouped.rows.add(result)).CopyToDataTable

Hope this may help you

[amy93amanda (amanda)]

thank so much, mark as solution but i implement because actually need multiple columns to group by beside the first thanks!!

for this

(From d In tabla.AsEnumerable Group d By k=d(“Columna1”).toString.Trim , k2=d(“Columna2”).toString.trim Into grp=Group Let sumVal= grp.Sum(Function (x) CDbl(x(“Cantidad”).toString)) let rows=grp.FirstOrDefault Let ra = New Object(){k, rows(“Columna2”).tostring, sumVal} Select tabla.Rows.Add(ra)).CopyToDataTable

thanks also to the rest to find other threads an info to learn!!

[amy93amanda (amanda)]

also works!