How to Import CSV with chinese charater to Qlik View ?
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 :-
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.
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.