Generate Rows - Incremental Alphanumerical Codes

[ALT_2358]

Hi, 

I've trying to generate rows similarly to this post: Solved: Generate Rows: increment letters like numbers - Alteryx Community

The difference is that I want to do alphanumerical codes, i.e:

AA001

AA002

AA003

...

AB001

AB002

--

ZZ999

I can't seem to figure out how to do this. Would really appreciate any insight!

[AngelosPachis · Accepted solution]

Hi @ALT_2358 ,

I've created a workflow for you that I believe answers your question. Following the instructions in that post, I have generated characters from A-Z with a generate rows tool. Then with an append fields tool, I have created all combination between those letters and finally I have created the numeric code extending from 001 to 999.

Let me know if that worked for you.

Regards,

Angelos

[ALT_2358]

Wow, this is perfect - thank you so much!!