So if these are the official 2 digit country codes...
then Tableau should bring them up. I just did a quick import from the Table on the attached, and Tableau managed to Map most of them (US and ID are the right ones for USA and India)
Tableau may not have, naturally, picked up that this is a geographic field (as it would if the field were called City or Country)...so you may need to tell Tableau that your field is a country field
Hope that helps.
3 of 3 people found this helpful
Alternatively you could import the 2 digit code to country name mapping from Wiki site (or other resource)...
If you open up a google sheet and put this formula in a cell
it will import the table from the Wiki article (clever Google sheets!!)...you could then join/vlookup to get the country names in. In my quick test Tableau did pick up all the country names.
Let me know if you don't use GSheets and I can attach this as a .csv
Thank you all,
its working awesome....
1 of 1 people found this helpful
There seems to be some issue with the two-letter country code (AKA: alpha-2 code).
Plotting alpha-2 code showed 69 Unknown countries....!!!
End users wont be happy to edit location for each country, so i've reported this to the tableau_dev team
Hopefully they can map alpha-2 code to respective countries.
By the way if you used 3-letter country code every country maps accurately.
Pls use the alpha-3 code (instead of alpha-2)...