Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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);
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