Unique identifier for duplicate entries

[Pav]

Hi, I've a dataset with duplicate values and I would like to assign a unique identifier to each one of them.

For example I've a column with values: 1,2,2,3,4,5,5,5,5 they way I want this to be done is to append a "/" with a digit at the end.

So my outcome would look like this 1/1, 2/1, 2/2, 3/1, 4/1, 5/1, 5/2, 5/3, 5/4.

So basically start from "/1" on each new digit.

I acheived that in excel by using this formula:  =A1&COUNTIF(A$1:A1,A1)

Is there an equivalent to this in Alteryx?

[MarqueeCrew · Accepted solution]

@Pav,

I'm not in front of Alteryx at the moment, but here's my suggestion:

MULTI ROW Formula

Group by [FIELD]

Create a new variable [Domain Count] as "numeric" (Byte if 254 is big enough)

Formula would be:  Row-1:Domain Count + 1

Now you can use a FORMULA tool and concatenate these two fields as you like.

[Pav]

@MarqueeCrew

This works perfectly, thank you so much!