Separate delimiter CVS file

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

alteryx test.csv

alteryx read csv.yxmd

Datasets

Developer

Developer Tools

Reporting

Designer Cloud

Download

Documentation

Accepted answers

geraldo

@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

All comments

geraldo

@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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703