Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #111: Make a Weekly Challenge Dream Team!

justynam
8 - Asteroid

Ughh, I spent a lot of time trying to get it - Alteryx kept giving me some strange errors.

Then finally I disconnected Optimization tool and connected it again. And suddenly everything started to work :-)

 

Anyway, it was a good exercise to find out how to use Optimization tool

aristiguieta
8 - Asteroid

this was trickier than I had expected, but it was definitely cool to be able to solve a system of hundreds of equations by using the optimize tool. 

 

the tool is definitely not easy to configure, but having this as a reference (translating the equations to the tool inputs) may help!

 

:-)

kelly_gilbert
13 - Pulsar

My solution is pretty similar to many others...

 

Spoiler
I recently updated Alteryx Designer, so I haven't jumped through all of the IT hoops yet to get the predictive tools reinstalled. Therefore, I went with the heuristic approach! In this case, it yields the same results as the optimal solution.

challenge_111_result_team.PNG
challenge_111_result_count.PNG


challenge_111_workflow.PNG




jwlong91
8 - Asteroid

Really great challenge to learn how to use the optimization tool!  I am glad others posted a link to the Fantasy Baseball example to be able to better understand what the inputs to the Optimization tool needed to be.  It was very helpful.

 

Spoiler
Challenge 111 Screenshot.JPG
RichoBsJ
11 - Bolide

Hi! Here my solution :)

 

Spoiler
challenge_111.PNG
JoshuaGostick
11 - Bolide

First time using the Optimization tool and definitely won't be the last!

Spoiler
challenge_111.PNG
ipeng
8 - Asteroid

My solution attached.

This challenge is very similar to the baseball player lineup one in the past, but simpler. 

Optimization tool rocks!

Kenda
16 - Nebula
16 - Nebula
Spoiler
At first, I was going to try all of the combinations of people and scores/prices, but that was taking wayyyyyyy too long...
Capture.PNG

So I tried a different route. I definitely relied heavily on this tool mastery to help solve this one! 
2.PNG

It's crazy to think that just one year ago, when this challenge was originally posted, I had only done 12 challenges! Now I'm on my way to 100% completion!

echuong
8 - Asteroid

Hope to be drafted one of these days!

hbraunius
8 - Asteroid

My solution attached. First time trying the optimization tool! Had to 'cheat' and look at how others configured it.