wsnyder
Board Regular
- Joined
- Sep 23, 2018
- Messages
- 224
- Office Version
- 365
- Platform
- Windows
Hi all,
I've gone wrong in creating a Power Query Function to scrape a website and I cannot figure out the error
Any ideas?
Thanks,
-w
I've gone wrong in creating a Power Query Function to scrape a website and I cannot figure out the error
Power Query:
(MyPage as text) =>
let
Source = Web.Page(Web.Contents("https://footballdatabase.com/ranking/world/"&MyPage&"))",
Data0 = Source{0}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data0,{{"Rank", type text}, {"Club / Country", type text}, {"Points", type text}, {"1-yr change", type text}})
in
#"Changed Type"
Rich (BB code):
Error message:
Expression.SyntaxError: Token Comma expected.
Any ideas?
Thanks,
-w