Error reading text file

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?

image.png

Workflow

Accepted answers

sufregs

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.

All comments

binu_acs

@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

Thanks all.

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703