Solved! Go to Solution.
Can you give an example of the output you wish to create?
My goal is to assign a unique alphanumeric ID to my person level data. I do not want to use the current Person ID with alpha added to as a prefix. I need Alteryx to create completely new ID.
Example:
Current ID = Person# 100100
Newly assigned alteryx ID = AB100111
With the "newly assigned alteryx ID" the alpha prefix can cycle through the alphabet and restart.
Example AA, AB, AC.... ZZ... AAA, AAB, AAC...ZZZ... AAAA, etc.
I followed this thread to create the numeric part of the ID - Alphanumeric RecordID
However, I'm stuck on how to incorporate the ASCII decimal value into the RecordID
Thank you!!
With this sequence, I would need to generate a column similar to "NUM" (from the previous workflow) that would be used when I join the Prefix list to my Person list, correct?
Yes, exactly.