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
5 - Atom

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

Highlighted
8 - Asteroid

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

 

Highlighted
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
WorkflowWorkflowBaseX MacroBaseX Macro
Highlighted
Alteryx
Alteryx

Loved it! Brought me back to ... 

Spoiler
binary representations!

Here's my dynamic solution:

154.JPG

 

 

Highlighted
Alteryx
Alteryx

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

 

Spoiler
 
Highlighted
12 - Quasar
12 - Quasar

Fun excercise @MarqueeCrew !

Highlighted
11 - Bolide

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





 

 

 

Highlighted
14 - Magnetar
14 - 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

 

Highlighted
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
Highlighted
9 - 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