I am automating a basic stocks task.
I am copying values(Company names) from excel column, googling its stock price and pasting that price to its relevant cell beside.
But the problem i am facing is that rpa express pastes prices in excel from a cell below the desired cell.
PFA screenshot of action flow and excel result of the action flow.
It happens because when you join strings in step 9, you use an empty string “csl” at the beginning. So instead of 3 values, your final list has 4.
Instead of joining and then splitting strings, you can use Expression action and directly append “tempprice” value to “comppricelist”.
Thank you @ashapkina for the help.
It worked fine.
Glad it helped