topic Re: Importing a Web file in the script, 2 fields not found in QlikView

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

maudifer — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

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

maudifer — Fri, 18 May 2018 15:39:38 GMT

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);

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

cdss-developer — Mon, 16 Sep 2019 08:21:50 GMT

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