Hello, I need to go through multiple pages, extract a table, and then append it to an excel file. Is there a way to use a loop for this? I don't want to manually capture each table. Thank you
Already have an account? Login
Login to the Pathfinder Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Use a If statement to check if "next" hyperlink still exist. If so, click on next and recapture the table again
Hi @Liam O'Dowd
You can use a while loop with object exists so it will click on next until it is disabled/hidden, you can use get table from recorder>capture
Hi @Prankur Joshi thank you for responding.
When the bot clicks next, the recorder action in the while loop doesn't update the URL so it is capturing the data on the first page only. I dont see a way to edit the link. Any ideas on how to resolve this?
Yes @Liam O'Dowd this is because for every page URL may be different/dynamic so you will have to use wild cards in like * or some variables so that your code will run for each page
See this thread
Thanks for your help I got it figured out!