Forum Discussion

Juri_Messenboeck's avatar
Juri_Messenboeck
Copper Contributor
Dec 24, 2019

Changing data from imported websites

In Leila Gharani's video (https://www.youtube.com/watch?v=NdUZx_yyEqY&ab_channel=LeilaGharanihttps://www.youtube.com/watch?v=NdUZx_yyEqY&ab_channel=LeilaGharani) she shows how to import weather data ...
Formulas and Functions
Juri_Messenboeck's avatar
Juri_Messenboeck
Copper Contributor
Dec 24, 2019

SergeiBaklan thank you for this, I appreciate it! However, when I paste the code (regardless which one) into the advanced editor in the power query editor, it says there is a "Token eof error", see image attached. The problem in both cases appears to be "let" at the beginning of both java scripts. 

How do I circumvent this so that it runs because it doesn't let me close it without removing the token eof error?

Thanks again for helping 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 25, 2019

Juri_Messenboeck 

You shall not paste but replace the code. It shall be no two sequential let ... in blocks in one query, only one. In this sample we have EOF error since first in ends the script

let
    One = "a"
in
    One

let
    Two="b"
in
    Two

However, blocks could be nested, like

let
    One = "a",
    Two = let Two="b" in Two
in
    One & Two

but that's not your case here.

By the way, script which works in Power Query is called M-script. Java script works on web site, weather.com.