Unique Identifier by ID

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:

current alteryx.jpg

Wanted Scenerio:

Want alteryx to do.jpg

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

Preparation

Accepted answers

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

Sample Unique Ident by ID.yxmd

All comments

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.

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

Sample Unique Ident by ID.yxmd

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

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

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!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703