Error reading text file

[sufregs]

I have a text file as input data. However, when I run the flow, i keep getting an error message 

_CustomerMaster.txt: record 239 is too long, and File/Field Layout 'allowLongLines' isn't checked. I have checked "allowLongLines" but still get the same error. I even tried reading the file as a csv with delimiter \n and field length 999999 but it still throws me the error. How can i resolve this?

[binuacs]

@sufregs , can you try using the delimiter '\0'?

[jrlindem]

Are you able to attach any part of the data, including that line?  I'm guessing its proprietary information, but worth an ask.  Maybe you can de-identify the record but retain the length?

Otherwise, I think you've tried the obvious:  Allow Long Lines with increasing the length.

Have you tried bringing the data in as a different file format?  I know you said Text, but maybe you could try as a single field CSV and then parsing it after it's in?

[sufregs · Accepted solution]

Thanks all.

I tried bringing it in as a csv and was still getting same error. I later noticed that I had the same input file in another part of my workflow that I hadn't changed (use csv and \n and increased file length). Once I changed it, it worked fine!

I suspect that may have been the issue with the "AllowLongLines" as well.

[jrlindem]

Great!  Glad I could get you in the ballpark and that you got it figured out.  Feel free to mark as solved if you get a chance.  

Otherwise, happy Alteryx'ing!