How To
Address the error “Too many fields in record #X.” We see this when users try to read in a .csv file. When error occurs, the file is not read.
Environment
Alteryx Designer
Procedure
There are a couple of different ways you can resolve this error.
First, in the Input Data tool configuration, check item 9 that says to "treat read errors as warnings". This allows the file to be read.
After the procedure, the error becomes a Warning. Now you can investigate why the error occurs in the workflow.
Another method is to read the file in with no delimiter. To do this, in the Input Data tool configuration, change the delimiter to \0.
Look at the image below. It presents steps to resolve the issue by building a workflow.
This process is illustrated in the attached workflow.
Once you have your data parsed back out into its fields, you can use the Dynamic Rename tool to correct your field names, a select tool to remove the original field, and a simple Trim() function to remove the extra delimiter from your data.
Attachments