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

All possible Permutations and Combinations of 5 columns

sowjanyayinti
8 - Asteroid

I am attaching the test data. The first tab is the input data. The output tab has a sample of what i am looking for. Basically, the workflow should be able to give me all the possible permutations and combinations of all the five fields.

 

From what I have seen (including the combination monster macro) - only one column is used as an input. In my test data, there are multiple columns and could have same value across multiple but should be considered different as it is under a different column. For example, M1 can be under UKEM and USEM. Anyone been through something fun like this before and can help me out?

1 REPLY 1
sowjanyayinti
8 - Asteroid

I resolved it actually by modifying the workflow that @ashissanpui gave  here Ashihssanpui's Solution. There might be much easier/better way but this works for me for now :). I split each column into its own text input

 

P&C Workflow.png  

Labels
Top Solution Authors