Unable to open csv in alteryx

[saachitalwar]

Hi, 

When I tried to open a csv file containing 292 columns, an error popped up saying "Too many fields in record#1"

So I changed the number of fields to 292 in the input tool as shown in the attachment. Now the fields are getting truncated to one column.

Can someone please help out with this please.

[apathetichell]

That column is the number of characters - not the number of fields. Set that at like 29200.  You should identify why you have too many columns... Is it because you have a delimiter in quotes? Do you have a delimiter wrong?

[saachitalwar]

It is still getting truncated. I don't think there's too many columns because of a delimiter error. All the columns contain different headers.

[Qiu]

@saachitalwar 
How about changing Delimiter to Comma?

[saachitalwar]

didn't work :/

[Qiu]

A sample input file would be good so we can take a closer look.