Input Data not showing text properly(Korean)

JunePark

Hi,

I'm trying to read some data which is in Korean.

I have two similar txt files which I've received from my client.

In the first capture, the text is shown properly, But the second doesn't.

When I open the txt file, both shows the text properly.

I haven't have had this problem before, and I'm not a technician and don't have a clue on what unicodes are and so on.

I'll attach the first N Rows saved as a txt file. (exported)

Can anyone help me out??

Thank you for reading, and hope you all have a wonderful day.

First N rows.yxzp

Input

Accepted answers

RithiS

Refer to this great Knowledge Base article on Inputting Data in Chinese, Japanese and Korean Characters.

It may depend on how the file is saved and with what encoding. You may also try using the ConvertFromCodePage function in the Formula and Multi-Field Formula tools. I was able to get it showing correctly with the function ConvertFromCodePage([Document Header Text], 10003), which is attached for your review.

First N rows - Rithi.yxzp

mutama

Hi @JunePark ,

We are pleased to inform you that with the latest release of Alteryx 2020.3, one of the new features which has been included is the inclusion of Korean Code Page 949 which has been added to the Input Data tool.

This configuration should help solve your issue in reading Korean Hangeul characters properly 🙂

For more info regarding newly-released features in the latest version of Alteryx, please follow the What's New Help Page here: https://help.alteryx.com/current/designer/whats-new

Best,

Michael Utama

All comments

RithiS

Hi @JunePark,

For KT_LINE_DESCRIPTION.txt, what is the Code Page (row 11 under Options)? It might be different than KT_HEADER_DESCRIPTION.txt.

JunePark

Thank you for your answer.

Unfortunately, they're both the same(ISO 8859-1 Latin I).

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703