Unable to open csv in alteryx

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.

Error Screenshot.PNG

Input

Accepted answers

All comments

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?

2024-05-29 172225.png

saachitalwar

didn't work

Qiu

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703