Calculation of times and more.

[rohit782192]

In Alteryx how we calculate if the value appear times or more.

Eg 50times or more.

[Qiu]

@rohit782192 
I am having diffculty to understand your intention here.
Can you give us a sample input and output?

[rohit782192]

Year	Amravati	Aurangabad
1990	Akola Country	Jalna Country
1991	Buldana Country
1992		Nanded Country
1993	Washim Country
1994		Jalna Country
1995
1996
1997	Amravati Country	Jalna Country
1998	Yavatmal Country	Jalna Country
1999
2000	Akola Country	Jalna Country
2001	Akola Country	Jalna Country
2002	Akola Country
2003		Parbhani Country
2004		Parbhani Country
2005		Parbhani Country
2006		Parbhani Country
2007		Parbhani Country
2008
2009		Hingoli Country

How many County appear on the list 5 times or More

[atcodedog05 · Accepted solution]

Hi @rohit782192 

Here is how you can do it.

Workflow:

Hope this helps : )

[atcodedog05]

Happy to help : ) @rohit782192 

Cheers and have a nice day!