Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Separate delimiter CVS file

Danilo9017
8 - Asteroid

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 ? 

Danilo9017_0-1687435521000.png

Thank you

 

3 REPLIES 3
geraldo
13 - Pulsar

@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

geraldo_0-1687436871726.png

geraldo_0-1687436931471.png

 

DataNath
17 - Castor
17 - Castor

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:

 

DataNath_0-1687436832154.png

 

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:

 

DataNath_1-1687436868327.png

 

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

 

DataNath_2-1687436898136.png

 

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
8 - Asteroid

Hi @DataNath @geraldo 

Thank you for your feedback!

Labels
Top Solution Authors