community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Can I give Alteryx a city, and it output the country it is located in?

nmonette
5 - Atom
‎01-25-2022 02:13 PM

i have a list of 88,000 cities and I need the country of each.  Can Alteryx potentially give me each country the given city is located in?

 

Thanks!!

Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus
‎01-25-2022 02:22 PM

London = Canada, or United Kingdom?

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Reply
0 Likes
Qiu
20 - Arcturus
20 - Arcturus
‎01-25-2022 08:26 PM

@nmonette 

It turns out there is also London is the USA. 😁

I download the city list from here, then we use a simple join tool.

0126-nmonette.PNG

0126-nmonette.yxzp
Reply
0 Likes
learn more about the python upgrade coming in may 2024
Labels