Encoding Problem(Checked with ConvertFromCodePage funciton)

[JunePark]

Hi,

I'm currently using raw data written in Korean.

I'm not sure what this file is encoded on, but Alteryx is unable to read it properly.

Since I don't know what the original code is, I've used a batch macro to read data's first two lines via the function ConvertFromCodePage, applying all codes available in Alteyrx(Codes from : https://help.alteryx.com/current/CodePages.htm)

However, the result showed that none of the codes converted the data properly.

Is there any other way/solution to fix this?

By the way, the original data is read properly when I open it with notepad.

[DavidP · Accepted solution]

Here's a good article to read on loading CJK text  https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Inputting-Data-in-Chinese-Japanese-...

You need to make sure that the characters are loaded as double byte characters into a V_WString datatype. V-String does not support double byte characters.