community Alteryx IO Mission Control
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

Dev Space

Customize and extend the power of Alteryx with SDKs, APIs, custom tools, and more.
SOLVED

Data Analysis

AS
8 - Asteroid
‎01-26-2022 12:28 AM

Hi there,

 

How we can check how many counties appearing on this list 5 times and more?

 

YearAlabamaArizonaArkansasCaliforniaColorado
1990 Yuma County Imperial CountyConejos County
1991 Yuma County  Costilla County
1992 Apache CountyWoodruff CountyColusa CountySan Juan County
1993 Yuma CountyPrairie CountyColusa CountySan Juan County
1994 Yuma CountyMississippi CountyColusa CountySan Juan County
1995 Yuma CountyPhillips CountyColusa CountySan Juan County
1996Wilcox CountyYuma CountyRandolph CountyColusa CountySan Juan County
1997Greene CountyApache County Colusa CountyDolores County
1998Greene CountyYuma CountyRandolph CountyColusa CountySan Juan County
1999 Yuma CountyWoodruff CountyColusa CountySan Juan County
2000Wilcox CountyYuma CountyJackson CountyColusa CountySan Juan County
2001Winston CountyYuma County Colusa CountySan Juan County
2002Wilcox CountyApache CountyMississippi CountyColusa CountySan Juan County
2003Franklin CountyApache CountyMississippi CountyColusa CountyCostilla County
2004Wilcox CountyApache County Colusa CountyCostilla County
2005Bullock CountyYuma County Colusa CountyCostilla County
2006Bullock CountyYuma County Colusa CountyCostilla County
Reply

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova
‎01-26-2022 12:40 AM

Hi @AS 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1643186418827.png

 

Hope this helps : )

 

County.yxmd
Reply
0 Likes
AS
8 - Asteroid
‎01-26-2022 12:57 AM

thanks @atcodedog05 

Reply
0 Likes