topic Re: CodePage flat file in QlikView

CodePage flat file

Anonymous — Mon, 03 Mar 2014 17:56:15 GMT

Hello,

I have a flat file containing datas from China, Korea, Taiwan, Hong Kong and Singapore. Name of poeple should be in his own language. For Chinese Korean and Taiwanese, i can not get a good result (for others countries, values are in latin).

When i load the file the codepage is set for all value but it's not the same for thoses languages. I tried to use applycodepage, but without succes.

Does anybody got an idea?

Thks

Vincent

Re: CodePage flat file

Mon, 03 Mar 2014 18:01:42 GMT

Vincent,

Can you "cut" the file or do several loads (with a WHERE statement) so that you can apply several code pages.

Fabrice

Re: CodePage flat file

Anonymous — Mon, 03 Mar 2014 21:25:59 GMT

Fabrice,

First of all, thks for replying.

Several files or load is going to work for sure. I was trying to load file at once...

Vincent

Re: CodePage flat file

agilos_mla — Mon, 03 Mar 2014 21:28:29 GMT

Hi,

Force the unicode format in the load statement wiht the 'utf8' keyword.

Example:

(txt, utf8, embedded labels, delimiter is '\t', msq);

Re: CodePage flat file

Anonymous — Mon, 03 Mar 2014 21:40:42 GMT

I have already tried utf8/7 or unicode and values are not properly reconized after load statement

Vincent