Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #52: Solving the Knapsack Problem

rmassambane
10 - Fireball
 
tammybrown_tds
8 - Asteroid

My solution is just a rework of the posted solution.  I have NO IDEA what this challenge was asking, and after doing the rework of the challenge, I still have no idea.

 

Am I the only one?

JonathanW
8 - Asteroid

This challenge took me a fair bit of time but I really enjoyed it! I haven't used the optimization tool before, so it was great learning how to use it! 

 

I made a macro that returned the optimum $ based on user input box weight and number of boxes.

 

 

Spoiler
JonathanW_1-1578526607115.png
JonathanW_0-1578526589533.png
Nicholas_Bignell
8 - Asteroid
acrahen
8 - Asteroid
Spoiler
Ultrawide monitor came in handy for this one
acrahen_0-1579731885164.png
ponraj
13 - Pulsar

Here is my solution.  Workflow for finding unique combination of items took time. Thereafter, was able to achieve example output quickly. 

 

Spoiler
Capture2.PNGCapture.PNG
mbogusz
9 - Comet
Spoiler
2020-01-26 10_34_20-Greenshot.png
Nicholas_Bignell
8 - Asteroid
 
johnemery
11 - Bolide

This was a fun challenge; lots of different answers and methods posted. Very cool.

 

Spoiler
I went with a batch macro. The macro itself is rather simple and allows flexibility if the data set were to increase in size.

Capture2.PNGCapture.PNG

 

LindaLo
8 - Asteroid

I think the most difficult part is finding the non repeating combinations. 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Cross-Tab/ta-p/4368

check the above article out. 

A great challenge!