Count Occurences

[arzed0305]

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

[Luke_C · Accepted solution]

Hi @arzed0305 

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

[arzed0305]

Luke_C,
That was simply amazing!!!!

Thank you so much

[Luke_C]

@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.