How to sum up the Amount of Dublicate Id's in Data table In Linq

[adarsh_kotagiri]

Hi Team,

Here i am having the input data where the “ID” are repetitive so, here i need to sum up all the Duplicate ID Amount i.e. (GROSS and Net),

Please find the below screen shots

Input:

Required Output:

Input File:

Data.xlsx (9.3 KB)

Thanks in Advance.
Adarsh.

[Sanjit_Pal]

Hey @adarsh_kotagiri ,

You can refer to this video.

LINQ | LINQ Pivot Table Aggregation | Sum LINQ Pivot | LINQ Uipath | Uipath Tutorials | Coderslobby

Thanks,
Sanjit

[Savan_S_Bangoria]

Hi @adarsh_kotagiri,

Please try this code in the assign statement and let me know if it works,

(From row In dt.AsEnumerable
Group row By key = New With { Key .group = row.Item(“ID”) } Into grp = Group
Select dt.LoadDataRow(New Object() {
key.group,
grp.Sum(Function(row) Convert.ToDouble(row.Item(“GROSS”).ToString)),
grp.Sum(Function(row) Convert.ToDouble(row.Item(“NET”).ToString))
}, True)
).CopyToDataTable

Regards.

[fernando_zuluaga]

Hi @adarsh_kotagiri

wha about the following?

(From row In dtInput.AsEnumerable
Group row By sc = row("ID").ToString()
Into grp = Group
Let totalGross= grp.sum(Function (x) Convert.ToDouble(x("GROSS").ToString()))
Let totalNet= grp.sum(Function (x) Convert.ToDouble(x("NET").ToString()))
Let result = New Object() {grp(0)("ID"),totalGross, totalNet}
Select dtToWrite.rows.add(result)).CopyToDataTable

Regards

[adarsh_kotagiri]

Hi @fernando_zuluaga
Thank you for your time. its working fine now.

Regards,
Adarsh.

[fernando_zuluaga]

Glad to hear that, remember to mark as solution!

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

Regards!