Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #154: Permute the Data

Highlighted
Alteryx Certified Partner

Here's my solution

 

Spoiler
Screenshot 2019-06-22 at 22.45.19.png
Highlighted
7 - Meteor

A quick brute force approach

Highlighted
Alteryx Certified Partner

17

Spoiler
Capture.PNG
Highlighted
8 - Asteroid

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

challenge 154.PNG

Highlighted
8 - Asteroid

My Solution!!!

Highlighted
8 - Asteroid

My version.

Highlighted
Alteryx Certified Partner

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

 

Here's my take

 

Spoiler
154.png
Highlighted
11 - 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
Highlighted
Alteryx 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
Highlighted
8 - Asteroid
Spoiler
154.PNG