Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

CodePage flat file

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

4 Replies
Not applicable
Author

Vincent,

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

Fabrice

Anonymous
Not applicable
Author

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

agilos_mla
Partner - Creator III
Partner - Creator III

Hi,

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

Example:

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

Anonymous
Not applicable
Author

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

Vincent