SOLVED

Have tried multiple ways can't get Georgia counties to map in Georgia (USA).

%3CLINGO-SUB%20id%3D%22lingo-sub-1867186%22%20slang%3D%22en-US%22%3EHave%20tried%20multiple%20ways%20can't%20get%20Georgia%20counties%20to%20map%20in%20Georgia%20(USA).%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1867186%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20tried%20multiple%20ways%20can't%20get%20Georgia%20counties%20to%20map%20in%20Georgia%20(USA).%26nbsp%3B%20At%20least%20finally%20got%20it%20to%20map%20in%20the%20United%20States%20and%20not%20all%20over%20the%20world!%26nbsp%3B%20When%20I%20look%20at%20the%20cards%20of%20the%20ones%20mapping%20elsewhere%2C%20they%20say%20the%20right%20location%20so%20really%20confused.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1867186%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1867233%22%20slang%3D%22en-US%22%3ERe%3A%20Have%20tried%20multiple%20ways%20can't%20get%20Georgia%20counties%20to%20map%20in%20Georgia%20(USA).%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1867233%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521337%22%20target%3D%22_blank%22%3E%40ShelliG_N%3C%2FA%3E%26nbsp%3BFoget%20about%20data%20typing%20as%20Geography.%20This%20mapping%20function%20is%20far%20from%20reliable%20and%20you%20need%20to%20play%20around%20a%20bit%20with%20columns%20headers%2C%20and%20names%20of%20the%20areas%20you%20want.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20you'll%20find%20your%20own%20file%20a%20better%20map%2C%20though%20it%20might%20still%20not%20be%20100%25%20correct.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1867258%22%20slang%3D%22en-US%22%3ERe%3A%20Have%20tried%20multiple%20ways%20can't%20get%20Georgia%20counties%20to%20map%20in%20Georgia%20(USA).%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1867258%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BYou%20were%20able%20to%20do%20that%20without%20the%20Geography%20data%20type%20-%20I%20didn't%20try%20that%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%20Thank%20you%20for%20the%20fast%20response.%26nbsp%3B%20Still%20a%20few%20counties%20missing%20but%20I%20can%20play%20with%20it%20to%20get%20it%20to%20work%20for%20me.%26nbsp%3B%20Really%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Have tried multiple ways can't get Georgia counties to map in Georgia (USA).  At least finally got it to map in the United States and not all over the world!  When I look at the cards of the ones mapping elsewhere, they say the right location so really confused.

4 Replies
Highlighted
Best Response confirmed by ShelliG_N (Occasional Contributor)
Solution

@ShelliG_N Foget about data typing as Geography. This mapping function is far from reliable and you need to play around a bit with columns headers, and names of the areas you want. 

 

Attached you'll find your own file a better map, though it might still not be 100% correct.

Highlighted

@Riny_van_Eekelen You were able to do that without the Geography data type - I didn't try that   Thank you for the fast response.  Still a few counties missing but I can play with it to get it to work for me.  Really appreciated!

Highlighted

@ShelliG_N I suspect that the missing counties are ones that also exist in other states, or even other places in the world. Perhaps not all, but as said, this tool is far from reliable and your "problem" is discussed pretty often in this forum and mostly encountered outside the US. It's all about testing your way around. Sometimes with geography data types but mostly not. Just changing the column header sometimes helps. Quite unpredictable. Good luck!

Highlighted

@Riny_van_Eekelen yes, the last three worked when I added: ", Georgia, United States" - strangely it broke everything when I added that to all the counties - but I got what I need now and really appreciate the help!