In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more 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