Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
73
Views
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
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