Hi all -
My source data is a large .txt file. However, I have noticed there are issues with the format of some of the data, with some lines truncated and the remainder of the line dropping to the line below. The break always appears to be at the same point (after the invoice number) but there doesn't appear to be any logic as to which line gets truncated.
Is there a way I can use Alteryx to repair these lines? Any help gratefully received. I include a sample of the affected .txt input files.
Regards
RDF
Solved! Go to Solution.
Hi,
Yes, just configure the Input Data tool > 7. Field Length. Default is 254 but you need to set it to something larger e.g. 999 so that there are no more conversion errors with "truncated records".
Thank you for the response. I have already set the field length to 1000000 and it still isn't pulling in correctly.
Thanks for the response. Brill, that seemed to do the trick. What difference does it make changing the Code Page to ANSI - Latin I make?
RDF
Well, I believe none... I was just testing during input :)