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