Alteryx Designer Desktop Discussions

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

Text file - struggling to read the file

J_SS
5 - Atom

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.

1 REPLY 1
alexnajm
17 - Castor
17 - Castor

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

Text file - struggling to read the file.PNG

Labels