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.
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