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

My solution for the challenge, although I admit I feel it is overshooting the problem.

Meteoroid

Here is my solution. It works with different toggle options but not with different tool options (yet). Maybe it works when I add an interative macro.

Spoiler
solution.PNG

 

Alteryx Certified Partner

a messy solution this week. with a bad base X macro that will create more problem then when it solve but wanted to get somethign in before the weekend.

 

Spoiler
challenge_154_Done_img.pngWorkflowconvertToBaseX_img.pngBaseX Macro
Alteryx
Alteryx

Loved it! Brought me back to ... 

Spoiler
binary representations!

Here's my dynamic solution:

154.JPG

 

 

Alteryx
Alteryx

Tough challenge. I have a solution although it is not very dynamic.

 

Spoiler
 
Bolide
Bolide

Fun excercise @MarqueeCrew !

Fireball

This one was deceptively challenging! At first, I questioned the Advanced tag, but realized there was more to it than I anticipated. It's interesting to see the different ways everyone has solved this.

Spoiler
* Use the Generate Rows tool to create a row per scenario ([Tools]^[States] scenarios)
* Create a row for each scenario/tool
* Use a formula to identify the state for each row

challenge_154_workflow.png





 

 

 

Magnetar
Magnetar

My solution! I chose to create an app that would allow a user to enter their own choices for tools and their states. I then used an iterative macro to create the combinations for any number of tools/states. 

 

Spoiler
AppParameter.JPGAppResults.JPG

Originally, I tried to do a batch macro within an iterative macro - seemed like it should work, but couldn't get it to iterate, so I went with a different approach for just an iterative macro instead. Key tools in both the workflow and the iterative macro are Transpose & Cross-Tab, Multi-Row Formula, and the Append tool.

WeeklyChallenge154.JPG

Cheers!

NJ

 

Alteryx Certified Partner
Alteryx Certified Partner

I can't take much credit for this one; 6 months ago I was working on a client project with a very similar challenge, assessing fuelling options on a route (you either stop or you don't), with the objective to reduce total fuel cost by stopping at the cheapest locations.

 

@PhilipMannering stepped in and built the permutations solution for me which I've adopted here so it can be shared (Y)

 

Spoiler
2019-03-11_08-53-06.png
Comet

I was able to solve it but it's not a dynamic or elegant solution. Thanks for a tough challenge!

Spoiler
WC154 Permutations.png