community
cancel
Showing results for 
Search instead 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 Certified Partner

Here's my solution

 

Spoiler
Screenshot 2019-06-22 at 22.45.19.png
Meteoroid

A quick brute force approach

Alteryx Certified Partner

17

Spoiler
Capture.PNG
Asteroid

Here's my solution for this, took me longer than expected.

challenge 154.PNG

Asteroid

My Solution!!!

My version.

Alteryx Certified Partner

Pretty difficult, but a great opportunity to learn some more from others.

 

Here's my take

 

Spoiler
154.png
Bolide

Solution attached can work for up to 9 different switch positions.  Attached workflow has 5 options and 4 switch positions. 4^5=1,024 rows with all the possible combinations.  Tested to ensure no duplicates and correct number of rows.

154 Options.JPG154 Postions.JPG

154 Results.JPG

Spoiler
154 Workflow 1.JPG154 Workflow 2.JPG154 Results original.JPG
Alteryx Certified Partner
Spoiler
154. Data Analysis.PNG


Took me a while to figure out in my head how to do it, but the crosstab was the key! Good challenge
Asteroid
Spoiler
154.PNG