I loaded the files into Tableau Desktop 9.3 and didn't see any problems. What version of Tableau are you using?
Thank you for quick response. I am using Tableau 9.3 under Windows system
I did had those problem
And now I use NOTE book open the CSV docs and change all " to nothing, change all 'space' to nothing and then change all the ',' to 'space'and then import the data and then now it is fine.
But with out processing, I could not get right data setting in Tableau.
Are you using MacBook?
1 of 1 people found this helpful
I think all you need to do is to change "column separator" to something that matches your data.
Based on your other question I think your computer has regional setting that are different from what most of us have (decimal and thousand separator, date formats etc.) and Tableau is getting confused.
You can change separator (and few other attributes) on Data Source tab.
Your skoinfo.csv looks poorly formatted (lots of extra spaces added to the end of values). Make sure that Text Qualifier is set to " symbol and once you get data in Tableau - TRIM all those values.
Thank you so much. THe skoinfo.csv is directly from Teradata base and I save it as .csv .
So are you using Macbook? My computer is IBM thinkpad
I do have a Macbook but this particular issue is not platform specific.
These extra spaces around data (after and, for some columns, before) are not desired but not something you could not clean up.
p.s. I wonder if your data in Teradata has spaces in the data (can happen if you are using fixed width datatypes) or it's added during export...
Thank you I will ask my college and let you know later. Thank you!