Discussion board where members can learn more about Qlik Sense Data Connectivity.
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
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
chr(8364) as euro
and & chr(10) options, but no luck so far...
Go to Solution.
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);
It works fine, thanks!