I want to multiply the days and the distance.
Hi @helpplease
cdbl(CurrentRow.ByField(“Days”))*cdbl(CurrentRow.ByField(“Distance”))
Hi @helpplease
=> Use read range workbook activity to read the excel and store in to a datatable.
=> Use for each row in datatable activity to iterate each row
=> Take an assign activity inside for each, create a variable called result it will be in double
=> Assign → Result = CDbl(row(“Column1”)) * CDbl(row(“Column2”))
=> You can use the Result variable to pass anywhere.
Check the below workflow for better understanding.
Check the output below, for your reference I write the result in the result column.
Hope it helps!!
Use an assign activity where left side is multipliedValue and of type Double and right side is CDbl(currentRows(“Days”))*CDbl(currentRows(“Distance”))
@helpplease
CurrentRow(“Days”).ToString=Var1
Days=Convert.ToInt32(Var1)
CurrentRow(“Distance”).ToString=Var2
Assign: doubleVariable = Convert.ToDouble(Var2)
Days* doubleVariable
Hi @helpplease
Please find the below xaml
BlankProcess4.zip (153.4 KB)
O/P :
Input.xlsx (9.4 KB)
I hope it helps!!
If you got the solution for your query. Please mark it as solution to close the loop.
Regards,
Thank you so much!!!
1 Like
I changed the header to the date.
I’ve ticked add headers by why does it says column not found?
You can try giving index instead of column name
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.