How to update the extracted data if status is true colomns only using Reframewprk without queues

Hi Team,

I have one input file and bot will check whether the status colomn is true or not.
If status true bot will login the web application and extract the required data and put in same excel with additional columns like invoice, account number and invoice date like this .

Note: the extracted data will updated in only wheather the status is true.
Otherwise leave the false rows as it is .

This flow will be done on reframe work without queues.

I have done the flow in Reframewprk without queues but I haven’t add the logic like if status colomn is false bot didn’t the update the data .

Before updating the data bot must check whether the extracted date example account number is matched with input file account number or not .

If it is matching bot will update the required data in x,y,z columns.

Kindly suggest

@Baby123

Use the transaction number variable to know the row index in excel for the current row and update it

Cheers

1 Like

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