read in .txt file as fixed width text file - file format is not valid
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Error Message
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for your reply, It does this to any .txt file but for example that one.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
