Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

convert text files from UTF-16 to UTF-8

nadiamazlan
5 - Atom

Hello, I have a text files with code pages UTF-16, and I am having a problem which the Alteryx cannot read my data since its UTF-16. Is there a way for Alteryx to convert from UTF-16 to UTF-8? or is there a way for Alteryx to read UTF-16 flat files?

4 REPLIES 4
messi007
15 - Aurora
15 - Aurora

Hello,

 

Could you share a sample of your file? It will help us to you the solution.

 

However when you read the .txt file as csv you can change the page code in the input tool configuration :

 

messi007_0-1631087311518.png

 

Hope this helps,

Regards

 

nadiamazlan
5 - Atom

Thank you for responding, I cant share my files, but here is the dummy files. I prefer using txt files because its easier to divide the column rather than using csv files

atcodedog05
22 - Nova
22 - Nova

Hi @nadiamazlan 

 

Alteryx should be able to read it. Can you share us the error message.

 

You can configure like below. All text files will be considered as csv and you can define delimiter.

atcodedog05_0-1631089238547.png

 

Hope this helps : )

 

nadiamazlan
5 - Atom

Thank you, my error is that, I didn't define the delimiter (\0) and I'm usually used flat to open txt files. So for the code pages UTF-16, I can only used csv to read the files. 

Labels
Top Solution Authors