How to group rows that have similar information and add the values before we merge them?

[ANSHUL (MANTRI)]

Step:1

| A1 | a | 2.2

| B2 | b | 2.2

| B2 | c | 1.3

| B2 | c | 5

| A1 | d | 6

| A1 | a | 7

Step:2

| A1 | a | 9.2

| B2 | b | 2.2

| B2 | c | 6.3

| A1 | d | 6

any help @AkshaySandhu

[vickydas (vicky)]

Hello @ANSHUL
Check this post it’s similar to your post & download the workflow for better understanding

Sumup the value in column

Hello @priyankavivek You can use Linq Here First we’ll Create a list of a double Variable and assign this Code (From row In DT.Select Group row By id=row("C2") Into gg = Group Select gg.Sum(Function(r) cdbl(r("C3")))).ToList it’ll group by the table get the sum of number in 3rd column Second group by your Datatable using this code (From row In DT.Select Group row By id=row("C2") into gg = group select gg(0)).copytodatatable Then create another Datatable Variable and create a default view…

let me know if you didnt understand any part !!

[AkshaySandhu (AkshaySingh Sandhu)]

@ANSHUL I suggest you to review the @vickydas’s post…
this will definitely going to help you build the LINQ knowledge…
I was not able to find relatively better links but you can give below a try…
https://www.dreamincode.net/forums/topic/389471-linq-group-by-and-aggregates/

[ANSHUL (MANTRI)]

Hi All thanks for all the document and guidance,
Finally managed to create a LINQ to add the values of data type double for Col3:

(From p In dt.AsEnumerable()
Group By x= New With { Key.a =p.Item(“Col1”),Key.b=p.Item(“Col1”)}
Into Grp = Group Select obj.LoadDataRow (New Object() {grp(0)(3), grp(0)(4),Grp.Sum(Function( r) CDbl(r(“Col3”))), grp(0)(8)},False)).CopyToDataTable