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: 
paulyeo11
Master
Master

How to Import CSV with chinese charater to Qlik View ?

Hi All

I have a CSV file , which have chinese charater.  When i using my note book to open the CSV file , the chinese charater become funny charater look like below :-

paulyeo11_0-1596549280782.png

When i import the raw data , using the below auto generate script :-

Directory;
LOAD [Customer/Vendor],
[Customer Name]
FROM
SI_MC.csv
(txt, utf8, embedded labels, delimiter is ',', msq);

I google the past post , it said that i need to import as utf8 , below is the image i get from Qlik View for company field.

paulyeo11_1-1596549467636.png

Hope some one can share with me how to solve this ?

My note book is win 10 , i already install with chinese font , but when using excel open the CSV file , i still see funny charater. ( when i try to get the IT staff generate give me XLSX ( Microsoft Excel Worksheet ) , i can see the chinese charater , but for this project i must use CSV file. 

Enclosed my raw data file onlt 3 row.

1 Solution

Accepted Solutions
cwolf
Creator III
Creator III

The file is not UTF 8, it has a Chinese code page. You need to find out which code page was used when the file was created.
For example:

// Chinese Simlified (GB2312)
CP936:
LOAD
[Customer/Vendor],
[Customer Name]
FROM SI_MC.csv (txt, codepage is 936, embedded labels, delimiter is ',', msq);

// Chinese Tratitional (Big5)
CP950:
LOAD
[Customer/Vendor],
[Customer Name]
FROM SI_MC.csv (txt, codepage is 950, embedded labels, delimiter is ',', msq);

Result.png

 

View solution in original post

3 Replies
cwolf
Creator III
Creator III

The file is not UTF 8, it has a Chinese code page. You need to find out which code page was used when the file was created.
For example:

// Chinese Simlified (GB2312)
CP936:
LOAD
[Customer/Vendor],
[Customer Name]
FROM SI_MC.csv (txt, codepage is 936, embedded labels, delimiter is ',', msq);

// Chinese Tratitional (Big5)
CP950:
LOAD
[Customer/Vendor],
[Customer Name]
FROM SI_MC.csv (txt, codepage is 950, embedded labels, delimiter is ',', msq);

Result.png

 

cwolf
Creator III
Creator III

Ok, your file use Chinese Simplified as codepage. Loading with (txt, codepage is 936, embedded labels, delimiter is ',', msq) give the correct result.

paulyeo11
Master
Master
Author

Hi Sir

Thank you very much.

Paul Yeo