Alteryx Designer Desktop Discussions

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

CSV not reading in data properly giving error "Too Many Field in Record"

dmpope
8 - Asteroid

Hi there,

 

I'm trying to troubleshoot a workflow that another person built and I'm struggling to get the Input tool to read in two of the CSVs. The configurations are set up the same as the one's that are working. For some reason, Alteryx is only reading in a single column and changing the data to what looks like some sort of metadata for the file:

 

dmpope_0-1687461248435.png

 

I selected "Treat Read Errors as Warnings" to see if that would fix, which it didn't. I've never seen this type of error before and I checked both of the files and I'm able to open them fine in excel (meaning the files aren't corrupted) so I would assume this is an error somewhere on the Alteryx side. I've also tried disabling AMP and that didn't work either. Has anyone else seen an error like this and know the solution?

 

Thanks!

 

2 REPLIES 2
acarter881
12 - Quasar

Hello, @dmpope.

 

My inclination is to increase the Field Length parameter. The solution marked here is more complicated, but may be what you need.

 

Hope this helps.

apathetichell
19 - Altair

read these two files in with no set delimiter (\0) - the messaging is odd - but it looks like it's saying it doesn't know how to split your files apart. There may be a delimiter in quotes.

Labels
Top Solution Authors