Forum Discussion
web scraping from multiple pages using power query
Hi All, New in power query, trying to scrape data table with multi web pages. Googling but not having the matching results 1 st website https://www.chcl.mu/storage-guide/ let
...
Riny_van_Eekelen, what I was trying to do , using power query to import all pages of the table on an excel sheet as there are page 1 , 2 3 and so on .
Using Windows 11 and office 365.
Using Windows 11 and office 365.
Richard072120 OK, then you need to create a custom function that will pick-up all the individual pages. The attached file contains such a function (very basic though), and only for the first link.
Difficult to explain since you mention to be new to PQ. The site in the link below is a good starting point to learn PQ. When you get to Chapter 18, you'll learn about custom functions.
- Riny_van_Eekelen, yes exactly I was looking for, but I was struggling since I am trying to learn this technique However " The site in the link below is a good starting point to learn PQ. When you get to Chapter 18, you'll learn about custom functions." I d'ont see the link , can you resend it .
Thank you for support.Richard072120 Sorry about that! Here it is.
- Riny_van_Eekelen Thank you