Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

Sort database in groups

Highlighted
6 - Meteoroid

Hi all

I'm looking for sort database in groups as the example below :

 

Untitled.jpg

 

 

Thanks :)

Highlighted
Alteryx Certified Partner

here are some results from a quick google search:

 

https://simplemaps.com/data/world-cities

 

https://www.kaggle.com/max-mind/world-cities-database

 

The Kaggle one looks good

 

Neil

Highlighted
Alteryx
Alteryx

Hi @KhaledF ,

 

To achieve this, you will have to use a lookup table to add the group (i.e. Country) to the City you have in your database. The links @LordNeilLord has provided will give you a data file that you can bring into your workflow and connect to your data on the Country field using either the Join or Find and Replace tools. After you have done this, you can use a Summarize tool to group the data by the new Country field you have added and then Sum the customers to provide the output you are looking for.

 

I hope this helps. Let us know how you get on.

 

Luke

Highlighted
Alteryx Certified Partner

Thanks @LukeM 

 

I forgot to add that bit to my response....I got distracted

 

Neil

Highlighted
6 - Meteoroid

thank you ,

i have a huge database , so think it will not work well and take long process.

 

Can you share the way please.

Highlighted
6 - Meteoroid

thank you

 

can you please share the answer

Labels