We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to find the combinations

Gsiva3
8 - Asteroid

I have a text as A & 1. I want to get a five letter word using this "A & 1" characters alone. 

So I need to find all the possible combination of this A & 1 when they form a 5 letter word.

 

Sample Output

combination 1 - A1AAA

Combination 2 - AAAA1

Combination 3 - AA1AA

 

Like this I need all the possible 5 word combination using only A & 1 as input data

2 REPLIES 2
steven_king
6 - Meteoroid

Hi @Gsiva3 here is one way to do it using Append tools. See if this works for your use case.

I used an input file with your two characters:
222.PNG

 

Then I built a chain of append tools with a formula at the end to concatenate them together:
333.PNG

Gsiva3
8 - Asteroid

Thanks for the workflow. Its working fine

Labels
Top Solution Authors