Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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