I want to extract data from the tables …but i don’t want to use multiple extract Data Scraping activity …because I don’t know how many tables will be there…its dynamic
We can do by using FindChildren(as suggested above). This will give you collection of UiElements(check for filters).
Loop through the output of “Find Children” in for loop. Get Each UiElement and find the Idx of it.
run Data Scraping and make sure to change to dynamic selector for idx value.
Check this example DataScrapingChildren.zip (1.3 MB) . Each table values extracted are written to csv values for reference. Hope it helps.
Do you think you could help me with my code? I have a list of websites where i have to extract all of the tables that are on the website, yet some have numerous tables while others only have 1 and nothing has worked so far. Also hopefully the tables that are all on one website can be archived in one excel. So far I can make all the excels of the websites with one table but not with various. Thank you!