Forum

How do I efficientl...
 
Notifications
Clear all

How do I efficiently extra multiple tables from multiple webpages?

2 Posts
2 Users
0 Reactions
73 Views
(@plasteredric)
Posts: 17
Eminent Member
Topic starter
 

I have set up a query that returns a list of approx. 30 webpages (these change daily) from a fixed web address, this is then used in a second query along with a custom function which gets a specific table from each webpage.

Is there a way of getting multiple tables from each webpage in a single function?

Each webpage contains four table which I would like to retrieve, and the only way I can figure it can be done is by having multiple instances of the secondary tables that each call a different function. Unfortunately this isn't an option as just running the single table took 8 mins to return the full list of tables.

 
Posted : 17/05/2021 10:01 am
(@catalinb)
Posts: 1937
Member Admin
 

Should be possible, but hard to say how without seeing the page structure, all depends on the web page structure.

 
Posted : 19/05/2021 2:09 am
Share: