I have a large dataset of cities, albeit with some unreliability where a province or street or alternative city name may be listed. When I go to fix those errors, I find that many not-at-all-obscure city names do not show up as options when typing a replacement for "Unrecognized." (ex: Perth, Ningbo, Puebla, Brasilia for just a few). It would be a mammoth task to look up Lat/Long for all these, and it seems wasteful when they should be automatically read. Am I misunderstanding this feature fundamentally? Why would so many cities not show up? Any explanation would be hugely appreciated. Thank you!
What country are you talking about ?
Do you have country &/or state dimensions in your data ?
Perth will work in Australia, but not the others.
In the end, it has to be on Tableau's list of known locations. That is expanding all the time, but it's obviously missing the ones you have now.