In the given data table
for each quality (group) if design and size are same then add total qty
Result should like
The excel file is attached here Sample.xlsx (8.8 KB)
In the given data table
for each quality (group) if design and size are same then add total qty
Result should like
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)
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