Error: Too many fields in record #1 for CSV file

[Kinetic_analytics]

Hello Folks:

Good afternoon. I am trying to work with CSV file. I have used the input tool then browser tool. After running the workflow I got the Error.

appreciate your help.

Thanks

[binuacs]

@Kinetic_analytics Can you provide your input file configuration?

[CharlieS · Accepted solution]

Hi @Kinetic_analytics 

This could happen where there's an unexpected delimiter (usually comma) in a field value. This would cause it to try and split that value into two fields, creating a mis-match.

Besides going back and fixing the value when the file in created, you could input all the data as text, then parse it out yourself in Alteryx. Set the delimiter to \0 , which is a shortcut for no delimiter. This will bring in your records from the csv, but all fields will be one text string. This way, you can browse the data in Alteryx and see where the problem is. You could even use a Text-to-Columns tool set to comma to split the records and see how the field count differs by record. 

This should lay out the problem for you to see. if you have any trouble, just let us know!

[Kinetic_analytics]

@CharlieS Thank you. Appreciate your help in my learning process.

[Kinetic_analytics]

@binuacs please check 

[binuacs]

@Kinetic_analytics Are you able to fix the issue which you were facing ?

[Kinetic_analytics]

@binuacs  Yes

[k3pineapple]

I simply convert csv to xlsx, since /0, then column to Text is not suitable for me