To Generate patterns for alphabets

[Ekmi9]

I wanted Generate patterns in alphabets. 

Like :

A,D G,H,K,N,Q,T,W,Z... ETC 

Can Someone help me on this

Thanks in advance 

[Emmanuel_G]

Hi @Ekmi9 ,

You can find one way to do this at this link : https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Generate-Rows-increment-letters-like-n...

PS : Workflow attached.

[Ekmi9]

Thank you for the solution but this solution will work till Z only i want this till A to  XFD.

[Qiu]

@Ekmi9 
Can you give a few more occurences after letter ”Z”？

[atcodedog05 · Accepted solution]

Hi @Ekmi9 

Here is how you can approach it.

1. Use generate row tool to generate values A-Z

2. Create another list that starts with blank and continues to A-Z. So we can generate A, AA where a place is blank

3. We can start using the append tool to create combinations. Use append tool twice for 3 place combination

4. Use formula tool to concat and create the string

5. Remove duplicates

6. Sort in order A,B,..Z,AA,AB,..ZZ,AAA,AAB,...,ZZZ

7. Use record ID tool to set position

After this you can apply logic to filter on the required positions.

BTW, I am really curious to understand what is the supporting use case where you need this.

Spoiler

Hope this helps : )

[atcodedog05]

Happy to help : ) @Ekmi9 

Cheers and have a nice day!