Error : Too many fields in Record
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
![](/skins/images/33644471E927638F516C93A75ADDEE18/responsive_peak/images/icon_anonymous_message.png)