Separate delimiter CVS file
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
