Understanding "Location names may exist in multiple countries or states" Warning Message

Product(s): Tableau Desktop
Version(s): 6.0, 6.1
Last Modified Date: 19 Jun 2014

Article Note: This article is no longer actively maintained by Tableau. We continue to make it available because the information is still valuable, but some steps may vary due to product changes.

When creating a map view in Tableau Desktop 6.1 and earlier, location names contained in your data may exist in multiple countries/regions or states. When the country/region or state is not specified for these location names, you may see the following warning message because Tableau is unable to plot the location on your map:

For example, suppose you want to plot the city of Aberdeen. Aberdeen happens to be the name of two cities in the United States (U.S.), and the name of another city in the United Kingdom (U.K.). 

Because the country and states are not specified for the city of Aberdeen, Tableau is unable to plot the intended location and displays a warning message.

To correctly plot Aberdeen, add fields to the Level of Detail (LOD) shelf that will remove ambiguity from the Aberdeen that you intend to plot.

In this example, adding the Country field will disambiguate Aberdeen at the country level. Because there is only one Aberdeen in the U.K., Tableau is able to plot it on the map. However, because the Country field is not enough to disambiguate the remaining two city locations in the U.S., you continue to see the warning message caused by the ambiguity at the state level.

Adding the State field will further disambiguate the location of the remaining two cities in the U.S.

Alternate Search Terms:geocoding, error message, multiple locations, map, map data, default location
Did this article resolve the issue?