CSV not reading in data properly giving error "Too Many Field 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 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:
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
