Counting the Duplicates

Marius_S

Hi everyone! I'm a new Alteryx user and I'm really excited to start exploring this software.

I would like to know if there is a way in Alteryx to count how many times a record has been duplicate.

My goal is not to group by the records and get a total count, but to take into consideration only the first record that appears into my data-set.

Below what is an example of what I'm doing in MS Excel in order to get the desired output:

A	=countif($A$1:A1,A1)
B
C
D
A
A
C
D

And my aim is to get the following output:

A	1
B	1
C	1
D	1
A	2
A	3
C	2
D	2

Is there a way to perform this in Alteryx? Any help is much appreciated!

Kenda

Hey @Marius_S!

Welcome to the community! I'm sure that you'll find this a great place to meet new people and receive lots of help when you are having troubles.

For this case, I would use a Sort first and sort by Field1. Then, use a Multi-Row Formula tool with the following expression:

[Row-1:New Field]+1

This should do the trick!