Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
maudifer
Contributor III
Contributor III

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

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 ?

Capture 3.JPG

Capture 1.JPGCapture 2.JPG

2 Replies
maudifer
Contributor III
Contributor III
Author

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
Contributor III
Contributor III

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