Hi,
I tried to map a list of ASEAN city names to Tableue Geo Map. Unsurprisingly, I got hundreds of unknown cities.
I would like to know if I can pull out a list of unrecognized cities so that I can work on those cities only.
It will be better if Tableau can pull out a list of records with the city name unrecognized. In this situation, I may use state or country data to corss-map the geo info.
Thanks!
DK
Hi,
I have resolved my issue by following instructions from this post View Underlying Data for Records with Unrecognized Zip Code
If any other has same problem as me, please also refer to the post above.
Thanks,
DK
Mar 6, 2017 12:07 AM
Thanks Deep, I have marked your answer correct as it may help others in the future...
Hi Deep,
Find my approach, Lets say you've below scenario.
I want to see list of 5 unknown countries.
1. Create a new sheet and drag the geo field on rows shelf.
2. Drag any one Longitude (generated) or Latitude (generated) tableau generated field on filters shelf and go to special and choose null values.
In this way you can get the unknown list.
Let us know If this help.
Mahfooj
Mar 6, 2017 9:06 AM
Hi Deep Kid,
Could you share the list of cities (and their country) that are failing to map in Tableau? I want to use this list to assess new data that we want to add to Tableau.
Thanks,
KentProduct Manager, Maps