Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Receiving "Too many fields in record #1326265" when reading a tab delimited text file

sonseeahray
8 - Asteroid

I am receiving "Too many fields in record #1326265" when reading a tab delimited text file in a workflow that I have been running successfully for months using the same daily file download.

 

Below is the normal input setting and a snapshot of the error message. I searched the forum and tried changing the field length.

 

sonseeahray_0-1604420901328.png

sonseeahray_0-1604422553477.png

 

sonseeahray_1-1604420938614.png

 

 

 

 

3 REPLIES 3
JosephSerpis
17 - Castor
17 - Castor

Hi @sonseeahray this post on the community might be helpful as it has some suggestions to deal with this error.

sonseeahray
8 - Asteroid

Hi @JosephSerpis, I read that one earlier and is where I got the suggestion to try changing the field size. I did also search for \t within the file as Charlie suggested.

sonseeahray
8 - Asteroid

Hi @JosephSerpis, I did not try "Treat Read Errors as Warning." This allowed the entire file to be read in. Thank you.

Labels
Top Solution Authors