Hi all and happy new year!
I came across the following issue and I would really appreciate some help.
I am working on map visualization (please see screenshot below), where I am trying to show Sales from stores (red) vs orders from the online store (blue). Some of the stores are located in small towns (<15k population) that are not automatically recognized by Tableau.
In my dataset, I only have information for Country and City, State is not included.
According to the following thread (Map Locations Not Recognized - Tableau ), even though State does not exist as a field in my data, the text file should include State in the hierarchy, in order to be aligned with the Tableau built-in geographical hierarchy:
- Country (Name)
Below an example of the csv file I tried to upload (the complete file is attached). I have intentionally left the State field empty, since this information is not available:
|United Kingdom||South Normanton||53.1082||1.3407|
I got the following error message:
I removed the hierarchy of Country-City in my workbook, removed the field State from the csv file, but still got the same error. If I don't remove the hierarchy, and exclude State from the csv file, then I get an error that State is missing. I guess this means that if you go for hierarchies, Tableau expects you to include the full hierarchy in the csv file.
Does anyone have any idea what I could do in such a case?
All I am want to do is upload the coordinates of only the cities that are not recognized by Tableau, by no chance do I want to extend the existing role and create a new role for cities, including the ones that are recognized (which is the case in most of the threads I have found in Tableau forums so far).
I hope the explanation is clear, if not, please let me know!
Thanks in advance!
Denis Windisch : I have written a comment under this thread (Custom geocoding - >600 ambiguous cities ). It seems that you have found the solution to this problem , but unfortunately I don't seem to understand exactly how you did it. Any feedback would be more than welcome