Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Count Occurences

arzed0305
6 - Meteoroid

Hi,

 

I am new to alteryx and would like to kindly ask your help if this is possible.

 

I would like to count how many times a data is present in a column.

 

Name     Count

Ryan      1

Ryan      2

Ryan      3

Ryan      4

Ryan      5

Jan         1

Jan         2

Jan         3

Jan         4

Jan         5

 

I'd like to achieve the 2nd column on the sample above that shows how many times the name appeared on the first column.

Is there a tool in Alteryx I can use or a formula that will return data I need?

 

Thank you

3 REPLIES 3
Luke_C
17 - Castor
17 - Castor

Hi @arzed0305 

 

Try the Tile tool using the unique value and choosing Name as the column

 

Luke_C_0-1648063981225.png

 

arzed0305
6 - Meteoroid

Luke_C,
That was simply amazing!!!!

Thank you so much

Luke_C
17 - Castor
17 - Castor

@arzed0305 Happy to help! If you're all set don't forget to mark my reply as the solution so it comes up for future people searching similar questions.

Labels