Alphanumeric RecordID

[lledl]

Hi,

I want to assign Record IDs to my record like starting from AB1 to AB1000032.. How do I do it in alphanumeric style

Thank you

[MarqueeCrew · Accepted solution]

1. RECORD ID
   1. STRING
   2. Starting Value 1
   3. Length 6
2. SELECT
   1. Change TYPE to VString and adjust length to 8 (or more)
3. Formula Tool
   1. Update your RecordID with the following code:

   2. "AB"+[RecordID]

4. Have a cup of coffee...

Cheers,

Mark

[ebirckholtz]

Hi Mark,

I found your response very helpful.

Do you know of any other ways to create an alphanumeric string? I was able to follow the first two steps to create the numeric half of the RecordID. However, I'm unsure how to assign a unique alpha ID.

Ideally I'd like the RecordID to be "AB011111", "AC011112", "AD011113" etc. 

Do you know if something like this is possible?

Thanks for any help!

Elizabeth

[LordNeilLord]

---

@MarqueeCrew wrote:

4. Have a cup of coffee...

@MarqueeCrew Does it have any impact on the process if you do 4 first?

[MarqueeCrew]

 Using an ascii table, you can identify decimal values as 65-90 as A-Z.  We know that there are 26 letters in the alphabet.  If you divide a number, say 345 by 26 you get:

13 with a remainder of 7.  I know that the 13th letter of the alphabet is "M" and that the 7th letter is "G".  If I were to add 12 to 65 (the 0 offset), I get 77 and looking that up in the table, I find "M" and I suspect that I'll find "G" by adding 6  to 65 (or by adding 7 to 64).

Back to my cup of coffee @LordNeilLord ....

So I can create values with much larger numbers by using this base26 logic if needed.  It just takes a little imagination.

Cheers,

Mark

[ebirckholtz]

Apologies  - brand new to using Alteryx.

How would I incorporate the ascii decimal values into the RecordID? I'm assuming a formula tool... just not sure which actual formula to use.

[MarqueeCrew]

@ebirckholtz,

Please do open a new question to the community and provide more details about your ID schema (what you want it to do).

Cheers,

Mark