I'm trying to build a power query that will return the Airport Codes, Names and Coordinates from Wikipedia.
Now I can get get a query to return the names and codes for any given letter with an ?M? query like
I can also append multiple querys to get all the letters.![]()
Please Login or Register to view this content.
But to get the coordinates, I need to access the child page for each airport. That means drilling through the the hyperlink links attached to "Airport name" to get to the page dedicated to that airport. I have no idea how to do this.
Any suggestions?
Bookmarks