I have an excel(a),Excel(B).

for each row in excel(A), go to the respective Excel(B) and calculate the sum of the column(4) value in excel(B) and again store value in column(4) of excel(A).Can anyone help me out please…Its Urgent

I have an excel(a),Excel(B).

for each row in excel(A), go to the respective Excel(B) and calculate the sum of the column(4) value in excel(B) and again store value in column(4) of excel(A).Can anyone help me out please…Its Urgent

Hi

Welcome to UiPath forum

Can you elaborate on how this step is done

Sum of column(4) means

Cheers @Usha_Sree

In the image 2, Assign activity, Quantity=Quantity+ Cint(CurrentRow(4)).What I need is, I want to take the Row(4) from Excel Vendor Inventory and not from Excel Vendor list

Fine

In that case use this as expression if you have the excel vendor inventory data saved as **dt_vendorinv** and vendor list as **dt_list**

**Quantity = Quantity + Cint(dt_vendorinv.Rows(dt_list.Rows.IndexOf(CurrentRow))(4).ToString)**

Where

dt_list.Rows.IndexOf(CurrentRow)) - gives rowindex from for each row loop which we can use to get the value in same of dt vendor list

we use this rowindex like,

dt_list.Rows(rowindex)(columnindex) - gives the value at specific row and column index where both index value starts from 0 for first row and first column

Cheers @Usha_Sree

Aah you are almost done

But requires a small change

In this below expression

Keep the Quantity before to = in To property of assign activity

And the expression to the right side of =

Keep that in Value part of Assign activity

It has to be used exactly the same way you did

Just a change in Value property of that assign activity

Hope this clarifies

Cheers @Usha_Sree

Actually i started learning uipath a week before. I didn’t understood what you exactly said.

can you elaborate it

Here it is @Usha_Sree

Have a view on these academy courses

It would really help a lot

https://academy.uipath.com/learningpath/datatables-and-excel-automation--with-studio-v20194

https://academy.uipath.com/learningpath/datatable-row-selection-tutorial

Cheers

My issue was solved with the help of below query…Hope it helps.

dtTesting.AsEnumerable.Sum(Function (x) If(Double.TryParse(x.item(“Column2”).ToString, Nothing), Double.Parse(x.Item(“Column2”).ToString), 0))

here just change the “column2” to the respective column you have in your excel which you want to get total sum.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.