Hi everyone! I'm starting my journey into this, and decided to give it a try to a larger dataset, the thing is the it doesn'y read properly, First I show How it should be (from kaggle) then how de excel looks like, and then what Tableau does:
Does anyone know what can I do? I tried to look for it here but find nothing, sorry:(
Thanks and all effort is appreciated.:)
3 answers
Hi Luis,
It looks a bit like your CSV is being split (delimited) on spaces not commas.
If you right click you csv in the Data Source pane and select Text File Properties...
What do you see for "field separator"? Space or Comma? If you see Space try changing it to Comma... worth checking the text qualifier is a double quote too.
Ta, Steve.
