Generate Rows for Alphabet increment stops at Z. Need more

[HW1]

As the question states,

I want to generate dummy variables which usually are more than A-Z.

The attached workflow stops at Z. I want the loop to continue from A-Z then AA, AB to ZZ and then AAA, AAB to ZZZ and so on

I have a start from A and the end to ZZZZ but still the generate rows stops at Z. How can I continue further?

[atcodedog05 · Accepted solution]

Hi @HW1 

CharToInt() convert characters to their ASCII number. ASCII list has only A-Z and doesn't include AA-ZZZZ

https://www.techonthenet.com/ascii/chart.php

Hence the above method will not work in the required use case.

You can use a method like below

1. Create a List of A-Z

2. Creare a List of Blank, A-Z. Blank is required to generate A, AA where alpha is accompanied by blanks.

3. Use the append tool to create combinations of these

4. Use the sort tool to sort them in the required order

5. Concat the fields in the formula tool to create the final string

Try building it yourself. Refer below only if you get stuck.

Spoiler

This process can be automated by converting this into an iterative macro. Here is the reference link.

https://community.alteryx.com/t5/Interactive-Lessons/Creating-an-Iterative-Macro/ta-p/657925

Give it a try and let me know.

Hope this helps : )

[atcodedog05]

Happy to help : ) @HW1 

Cheers and have a nice day!