How to add values of different rows for same name using LINQ queries?

[Mandava_Naresh]

Hi All,

Can someone help me in adding all the values of one user in below DT using LINQ quires ?

Input Data table

In the above data table I have to add UIST values 37+43 and want to convert into one row … Similarly for BOT store values 12 +21 should get added and want to convert into one row like below screenshot

Expected Out put data table

@J0ska @kumar.varun2

[Gokul001 (Gokul Balaji)]

Hi @Mandava_Naresh

How about this expression?

(From d In DtBuild.AsEnumerable
Group d By k=d("Name").toString.Trim Into grp = Group
Let nj = grp.Sum(Function (x) CDbl(x("Value").toString.Trim))
Let ra = New Object(){k,grp.First()(1),nj}
Select r = DtOutput.Rows.Add(ra)).CopyToDataTable

Regards
Gokul

[Marius_Puscasu]

Hello @Mandava_Naresh ,

Besides @Gokul001 'solution, please check these two topics:

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operators Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start # All Operato…

How to use LINQ [Basic to Advanced] in UiPath | UiPath

It should help you to understand what your are using within your UiPath project.

Best regards,
Marius

[Gokul001 (Gokul Balaji)]

HI @Mandava_Naresh

Check out this XAML file

GroupBySumBuildDt.xaml (8.1 KB)

Output

Regards
Gokul

[Mandava_Naresh]

Hi @Gokul001 ,

It worked … Thank you very much

Can we convert the value from string to int before we add values?