How calculate each item in excel

[Anand_Designer (Anand_RPA)]

Hi ,
i have an excel file in that Name and Qty column is there
i have to sum each item and write into another sheet

write into another sheet

can any one help ?
sample.xlsx (9.1 KB)

[Sudharsan_Ka]

HI @Anand_Designer

Checkout this thread

UiPath - Datatables, How to use GroupBy with SUM and COUNT functions

UiPath | LINQ Sum Function | Group Sum LINQ | Get Column Sum | Get Group Sum of Column with LINQ

How to use group by and get sum?

Yes. you should use assign activity. In the left hand side of assign acitivity you should use dt2, in the right hand side you should use Linq. Also see below updated linq: (From row in dt1.AsEnumerable Group row by sc = row(“STORE CODE”).ToString() Into grp = Group Let total= grp.sum(Function (x) Convert.ToDouble(x(“CREDIT”).ToString().Replace(“$”,“”).Trim())) Let result = New-Object() {grp(0)(“STORE CODE”),total} Select dt2.rows.add(result)).CopyToDataTable I missed keyword called Into…

Regards
Sudharsan

[fernando_zuluaga]

Hey

here is your solution
BlankProcess1.zip (11.6 KB)

Regards