Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Not applicable

When importing a website (which contains euro signs) I get wrong data

Hi,

I am importing data from a website (http://nl.wikipedia.org/wiki/Lijst_van_minimumloon_per_land), it's Dutch but it is imported fine

easy one:


LOAD
    Land,
    "Minimumloon in EUR" as euro

FROM [lib://Wikipedia]
(html, codepage is 1252, embedded labels, table is @1);

only the result remains:

â,¬ 94,79 instead of 94,79

I already tried some

load

chr(8364) as euro

autogenerate 10;

and & chr(10) options, but no luck so far...

1 Solution

Accepted Solutions
Employee
Employee

Re: When importing a website (which contains euro signs) I get wrong data

When you load the data make sure you have the Character Set set to Unicode (UTF-8) and the euro signs should load ok.

Or just change the connection string manually to (html, UTF8, embedded labels, table is @1);

2 Replies
Employee
Employee

Re: When importing a website (which contains euro signs) I get wrong data

When you load the data make sure you have the Character Set set to Unicode (UTF-8) and the euro signs should load ok.

Or just change the connection string manually to (html, UTF8, embedded labels, table is @1);

Not applicable

Re: When importing a website (which contains euro signs) I get wrong data

It works fine, thanks!

Community Browser