Error : Too many fields in Record

Question

Hi,

I am trying to read one txt file which has 100000 records. when i hit load , after few minutes, iam getting error stating too many fields in record #11878. but when i check the input txt file, all line has same kind of records and data types as well..

Is there any specific reason for this issue?

-Karthick.

AngelosPachis · Accepted Answer

Hi @Karthick461 ,

Which character are you using as a delimiter to split to the different columns?

By the look of it, it seems that row 11878 has one extra delimiter compared to the records before that, which causes that error message. What you can do instead is load the text file without using a delimiter and parse it in Alteryx, rather than separating to different columns in the Input Data tool.

Hope that helps,

Angelos