Importing a Web file in the script, 2 fields not found

[maudifer]

Hi All,

i am downloading a web file file but 2 of the fields can't be found. I think this because there sorting functions in those fields in the website. Do you know any way to get around that ?

[maudifer]

here is my script by the way:

LOAD [Currency code            ▲▼] as [Currency code],

     [Currency name            ▲▼] as [Currency name],

     [Units per GBP],

     [GBP per Unit]

FROM

[https://www.xe.com/currencytables/?from=GBP&date=2018-05-18]

(html, codepage is 1252, embedded labels, table is @1);

[cdss-developer]

Hi,

Try this;

LOAD
@1 as [Currency code],
@2 as [Currency name],
@3 as [Units per GBP],
@4 as [GBP per Unit]
FROM
[https://www.xe.com/currencytables/?from=GBP&date=2018-05-18]
(html, codepage is 1252, no labels, table is @1, filters(
Remove(Row, Pos(Top, 1))
));

Greetings,
Eelco