Find the group having duplicate values and sum the column

In the given data table image

for each quality (group) if design and size are same then add total qty

Result should like image

The excel file is attached here Sample.xlsx (8.8 KB)

Check this workflow and output file, @Soniya215
Excel_DataUpdation.xaml (21.8 KB) Output.xlsx (7.5 KB)

1 Like

Thanks @Manish540 the workflow worked correctly

if i want to do sum of another column which is present after Total like Total1

what changes should i do in
(From p In qua.AsEnumerable() Group By col1=p(“Design”),Notes=p(“Size”) Into grp=Group Select qua.Clone.LoadDataRow (New Object() {grp(0)(0),grp(0)(1),grp(0)(2),grp.Sum(Function(x) x.Field(Of Double)(“Total Qty”)),grp(0)(3)},False)).CopyToDataTable this assign activity.

I just want to add one more column to do the sum in this query.

Thanks again

Then use this below code, @Soniya215
(From p In qua.AsEnumerable() Group By col1=p(“Design”),Notes=p(“Size”) Into grp=Group Select qua.Clone.LoadDataRow (New Object() {grp(0)(0),grp(0)(1),grp(0)(2),grp.Sum(Function(x) x.Field(Of Double)(“Total Qty”)),grp.Sum(Function(x) x.Field(Of Double)(“Total1”))},False)).CopyToDataTable