Hi Guys,
There is data on a website in the form of a table, with links in it. I need to click on every link one by one and then after the link is there is another datatable from where numbers need to be extracted and pushed into the queue.
Please help how can I do it
Hi @Chetan_Wagh
First you have to extract it as datatable by using extract datatable activity. Use for each row in datatable activity to iterate the datatable. Use the click activity in the for each row in datatable activity.
Indicate the click activity to first link in the table in the website. Open the selectors of click activity, Uncheck the fuzzy selectors and image, check the strict selectors.
Create a variable and store the row value (Link) in the variable. Pass the variable to the strict selector of click by using aaname or relevant attribute in the Ui explorer.
When looping the every row in the datatable it will click on the every link in the datatable.
After clicking on the link it will open a other datatable in the website, use the extract datatable activity to extract it as datatable and use bulk add queue items activity to push the extract datatable to queues and you can use the queues for further use.
Hope it helps!!
After clicking on the link there is another table from where data needs to be pushed into the queue.
Also the above thing i am doing for a particular Branch code. So I am already using For each initially so that the whole process should be completed for 1 branch code and then it should move to the next one. But the problem is, it partially completes the process and immediately moves to next branch code halfway. Please guide on how to use for each wisely or maybe use other loop
@Chetan_Wagh Could you please elaborate your question for our better understanding. Please share your workflow.
Hi @Chetan_Wagh
So during the extraction the URLs also got extracted right. Then use for each datatable activity to iterate through each row and use go to URL activity (Pass the URL present in datatable) and extract the another datatable and add it to the queue.
Hope it helps.
Hi @Chetan_Wagh
Use the “Open Browser” activity
Extract Datatable
Use a “For Each Row” activity to iterate through each row of the extracted table data.
Use the “Click” activity to click on the link in each row.
Use the “Navigate To” activity to switch to the newly opened tab or window
Extract DataTable
Bulk Add Queue Item
“Close Tab” or “Close Window” activity
Hope it helps!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.