Separate delimiter CVS file

[Danilo9017]

Hi All

I am struggling with a CSV file. when i try to import on alteryx the file "alteryx test.csv" , but it seems that only all data are read in a column . I already put "," as delimiter but it seems not work. There is some way to separate the data ? 

Thank you

[geraldo · Accepted solution]

@Danilo9017 

the import is correct How was this strange looking file exported column names go from textbox13 to textbox308 and the records have quotes apparently involving several fields

change the configuration I passed below

seems to be from Salesforce

[DataNath]

Hey @Danilo9017, how are you expecting this to look in Alteryx? When I open your .csv in a text editor, I can see that all of the delimiters (commas) are contained within a couple of quotes:

As standard, Alteryx will ignore all delimiters within quotes, hence why they're all being skipped/not split on and you're just getting a single cell of data:

If we switch this to 'None' for example, then we can see the values begin to split out:

As I don't have much more context around your case, I'd recommend playing around with these settings based on the expected appearance and reporting back if you run into more issues.

[Danilo9017]

Hi @DataNath @geraldo 

Thank you for your feedback!