cancel
Showing results for
Did you mean:
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

## Challenge #154: Permute the Data

Alteryx

I really tried to get the advanced piece done for this one. I was able to get an dynamic number of states including having different numbers of states for each tool. My example shows three tools, one with two, one with three, and one with four states. I couldn't figure out how to get an dynamic number of tools, though. Looking forward to seeing others' solutions.

(In looking at some of the other solutions I think I bit off more than I could chew when I went for allowing different tools to have different numbers of states. If I kept them all the same I could have gone for the counting and base conversion approach I was thinking of originally.)

Alteryx Certified Partner

Solution attached.

First block is the basic solution and second part is the dynamic approach (it takes any number of tools / any number of toggle options!)

Spoiler

Alteryx Partner

on/off = binary

Spoiler
Alteryx Partner
Spoiler

Recently encountered a problem like this at work. My colleagues were able to help me solve it and one even told me it was a weekly challenge! So clever to use binary logic to do the combinations!

Asteroid

Put together a fully dynamic solution. The only required input is more tools in the original input.

Spoiler
Asteroid

Interesting challenge.