you tried using the geocode import? And are you trying to use these locations with Tableau as datapoints or do you simply need a map that includes the cities in the background?
One big thing.. your file looks like this:
This file has a single field when it is wrapped in quotes. It needs to be :
and you may need a schema.ini file as well - this is covered here: Create a schema.ini File
Also note that - at least to my eyes - the Province and District fields are the 2 distinct fields yet I do not see these in your data rows with seperation by comma. So one of those header rows probably needs to go. Make sure the # of columns in the header row matches the number of fields availble. Using Excel to create the csv file should do this for you if the data columns are all input as described so I'm not sure how this was created.
Fix up that data and give it another try.
Thanks for the suggestion.
1. May I ask how to create a .csv file as you said? I have tried very complicated procedure to create a csv file containing Chinese characters as the current one.
2. My goal is to merge the file with latitude and longitude into the other file which contains measures for those unknown cities, not to map the file with latitude and longitude columns, that is very straight forward.
I have two files. One file has many cities (districts) and their data (measure), but some of the cities cannot be recognized by Tableau. That is why I created a second file containing those unknown cities and their latitude and longitude. I want to use those two files together in Tableau to map, and to visualize the measures of all of the cities.
I have a book called Tableau Official Guide. In that book, it has a similar example. But I cannot repeat that example.
Are you using Excel as a data source?
Yes, I use Excel as my data file. Does that matter?
My case is quite similar to repeat a case in The Official Guide Tableau 9 book, but I cannot.