Start Free Trial

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