Need to get the no of Countries from the List.

[duttaabhishek7]

Hey All,

I have a file with list of country names in one column. I am trying to develop a workflow in Alteryx to count the no of times a country is appearing in the list. FOr example 

ALbania= 1

Algeria=4

Tunisia= 4

and so on.

[ShankerV · Accepted solution]

Hi @duttaabhishek7 

As per the attached sample file, there are rows containing country names separated with comma.

Step 1: Text to Columns tool

Column to split: Country

Delimiters: ,

Split to rows

Step 2: Data Cleansing tool

Leading and Trailing Whitespace

(Helps to trims the unwanted whitespace)

Step 3: Summarize tool

Country -> Group By -> Country

Country -> Count -> Count

Many thanks

Shanker V

[duttaabhishek7 · Accepted solution]

Hi @ShankerV ,

Thanks a lot for your input. I was able to use Text to COlumnn tool to separate all the countries in separate column. However not able to apply the appropriate configuration in Summarize tool. Can you please help.

[ShankerV · Accepted solution]

Hi @duttaabhishek7 

In Summarize tool, 

In the tab Actions, please format the below.

Field -> Action -> Output Field Name

Country -> Group By -> Country

Country -> Count -> Count

Please let me know if you need further assitance.

Many thanks

Shanker V