PDA

View Full Version : Tables not showing up in Query-Editor



BBMB
2017-03-22, 06:29 PM
Hello, I'm currently trying to access tables from the following website:

http://www.basketball-reference.com/boxscores/201702030ORL.html

The problem I am having is with the "Line Score" table and the "Four Factors" table. (line_score - four_factors)

This used to not be a problem, so I am wondering if the webmasters made it more difficult to access these tables. For some reason those 2 tables are not showing up in the Query-Editor for extraction.

Please can someone check to see if they have better luck?

I used to do regular web-query imports, to access the table data, but that stopped working after the webmasters commented the data in the source code. I had to start using Power Query, which did me well for some time, but now that isn't working anymore.

Any help would be much appreciated.

Thank you.

Ed Kelly
2017-03-22, 07:32 PM
BBMB,

Tried it with 2016 Excel Get Data and no luck, think the webmasters have played with the puppy, got this https://www.screencast.com/t/ZFtbzQZKjsL2 and none are the tables that you want

Ed

BBMB
2017-03-22, 08:06 PM
Thanks for trying Ed, even though you confirmed my biggest fear.

I guess Get and Transform has its limits.

I'm going to try and find another way to scrape.

Ken Puls
2017-03-22, 08:07 PM
Yep, looks like they are using javascript, which is a total killer for Power Query. :(

That's the big issue with referring to external pages... they're not under your control.