Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

To Generate patterns for alphabets

Ekmi9
8 - Asteroid

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 

5 REPLIES 5
Emmanuel_G
13 - Pulsar

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
8 - Asteroid

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

Qiu
19 - Altair
19 - Altair

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

atcodedog05
22 - Nova
22 - Nova

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
atcodedog05_0-1659511310974.png

Hope this helps : )

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Ekmi9 

Cheers and have a nice day!

Labels