SOLVED
Text file - struggling to read the file
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
J_SS
5 - Atom
12-14-2023
04:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a text file which is about 200mb and there are two columns in it. The columns do not have any delimiters. I was able to import the file in Alteryx. I converted it to fixed width file, but when I run the file. It throws error "record is too long, field layout 'allowlonglines' isnt checked". I have attached the sample file to show how the data looks in the text file. Can anyone suggest me how can this be achieved in Alteryx.
Solved! Go to Solution.
1 REPLY 1
18 - Pollux
12-14-2023
04:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Like the error indicates, is “allow long lines” checked when you do the fixed width option? Reading in your sample the way you described but with long lines selected worked perfectly fine for me

