Unique Identifier by ID

[JillWooster]

Hi - I'm looking to create anonymity in my survey data and cannot show the ID. I'm trying to find a way in Alteryx to not count each row in the Record ID field, but assign each ID their own identifier.  For an example, all the jwoosters in the ID field would be '1', and all the jbiglers would be '2' and so on.... see sample data example below.  

Current scenerio:

Wanted Scenerio:

Any suggestions you can provide would be most helpful. Thanks in advance for your guidance!  

[patrick_digan]

I would use a summarize to group on ID, then use a recordID tool, and then join it back based on ID to your original data set.

[tom_montpool · Accepted solution]

@patrick_digan is absolutely correct -- but in Alteryx there's often more ways than one to accomplish a task!

Try sorting on the ID and using a Multi-Row Formula...

[JillWooster]

You the man, Tom <virtual fist bump> .  This one worked for me. Thank you!!!

[JillWooster]

Thank you Patrick.  I'm going to try this one too.  :)

[nina2725]

Hi Tom, thanks for the solution. 

Is there a way to do that without sorting first?

I would like that my records don't change. 

Thanks in advance!