Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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