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?
Solved! Go to 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.