Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Unique identifier for duplicate entries

Pav
7 - Meteor

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?

 

 

 

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Pav
7 - Meteor

@

 

This works perfectly, thank you so much!

 

Labels