Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Unique Identifier by ID

6 - Meteoroid

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!  

17 - Castor
17 - Castor

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.

12 - Quasar

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

6 - Meteoroid

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

6 - Meteoroid

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

5 - Atom

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!