Extracting multiple tabs from single URL

[Syndicate_Admin]

Hi

I am trying to extract all three the data tables under Exposure breakdown from the Following URL

https://www.ishares.com/uk/professional/en/products/228522/blackrock-blk-developed-world-index-flex-...

They each have parts decriptors: #tabsSector, #tabsGeography , subtabsCountries, #subtabsRegion

Adding these onto the URL doesnt help. Are there any easy ways to extract all the table values?

[Syndicate_Admin]

Hi Stephen

I have been using the "Geta from Web". The Exposure data aren't visible if I just use the URL above. When I use any one of the # parts above I always only get the first table (Sector). I have looked at various solutions online for multiple pages of a table on a webpage. A number of those solutions require changing the URL to allow for multiple. They all are quite complicated for a novice.

Regards

[Anonymous]

Hi Bogle_SA1,

You can try the web connector in Power Query.

1.Open Power Query and navigate to the Data tab.
2.Click on Get Data and select From Web.
3.In the From Web dialog box, enter the URL of the webpage you want to extract data from.
4.Once the webpage loads, you will be presented with a preview of the data available on the page.
5.To extract a specific table, select it from the preview and click on Load1.
6.Repeat steps 3-5 for each table you want to extract.

Reference:

Power Query Web connector - Power Query | Microsoft Learn

For more complex data scraping, you can also try this feature: Get webpage data by providing examples.

Reference:

Extract data from a Web page by example - Power Query | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.