ASCII with RecordID

[ebirckholtz]

Hi all - How can I incorporate an ASCII decimal values into RecordID to create an alpha numeric value?

[derekbelyea]

Can you give an example of the output you wish to create?

[ebirckholtz]

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

[derekbelyea · Accepted solution]

This may take you down the right path......

[ebirckholtz]

Thank you!!

[derekbelyea · Accepted solution]

My previous workflow was flawed.  Please use this one instead.

[derekbelyea]

Here is a workflow segment that will generate 456,976 unique four character string values starting with  AAAA, AAAB, AAAC and so on.

[ebirckholtz]

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?

[derekbelyea]

Yes, exactly.