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?
Solved! Go to 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.
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 : )
Happy to help : ) @HW1
Cheers and have a nice day!