Alteryx Designer Desktop Discussions

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

read in .txt file as fixed width text file - file format is not valid

dlesny
8 - Asteroid

Hello

 

I have been using Alteryx for ages that way. Having a .txt file as input and reading it with "Read it as a fixed width text file"

As of today it comes up with   "File format is not valid" even if I try to read in the file that was ok yesterday. Now it does this to any txt file.

 

 

What can be the problem? I have never had issue with this before.

4 REPLIES 4
dhoover
5 - Atom

Can you attach a sample text file that gives this error? There could be certain errors with how it is being imported to the workflow.

dlesny
8 - Asteroid

Thank you for your reply, It does this to any .txt file but for example that one. 

dlesny
8 - Asteroid

I tried just to set it manually. File/Field Layout brings the error. I do not get to Description file and I can still do it as normal on second pc.

It must be some PC or Alteryx setting.

 

dlesny_0-1680098336930.png

 

dlesny
8 - Asteroid

Hi All

 

I found the problem in my case. It was Windows setting for "Beta: Use Unicode UTF-8 for worldwide language support" checked that was causing it.

Control Panel > Region > Administrative > Change System locale... Unchecking it sorted the problem.

 

dd280e56-91d5-4e76-b296-158ecc3fdd0a.PNG

 

Labels
Top Solution Authors