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
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.