Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a country titled People's Republic of China in the database and it shows in Qlik in the table as People's Republic of China . The inverted apostrophe is encoded as HTML character.
1. How do I fix this to shows People's ?
2) Why is it causing in Qlik ?
Hi,
you can create an inline table with the description of the characters.
MAP_Characters:
MAPPING LOAD * INLINE [
Code, Character
', "'"
];
Table:
LOAD
MAPSUBSTRING('MAP_Characters',Country) AS Country
FROM <table>;