Extract data from multiple tables on single webpage

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

for eg: in this URL below
https://www.marketwatch.com/tools/stockresearch/globalmarkets/intindices.asp

1 Like

Hi @Sparks811,

it seems like all are same template use find children activity to get all the table and you can append it after that.

Regards,
Arivu

can you please explain it in detail

Use find children activity to get all the tables.

Selector : <html title='International Indices -*' /> <webctrl id='intindices' tag='DIV' />

Filter : <webctrl idx='*' tag='TABLE' />

Loop it find children output.

Inside use data scrapping after scrapping store it into another table.

Regards,
Arivu

3 Likes

how we can use idx in selector …its showing invalid…
Can you upload an example

Hey @Sparks811

I just wanna know you do not want to deal with Headers before these separate tables?

Regards…!!
Aksh

Can you please send me the solution for this?

@Sparks811,

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.

@Sparks811 Did this help you?