# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

## Challenge #111: Make a Weekly Challenge Dream Team!

Highlighted
Alteryx Partner

Tough choice... 685 challenges if I'm not part of the team...or 681 if I am. Plus, 5k to spare in beers AND having @MarqueeCrew in my team?... seems like a no brainer...

Spoiler
1.Optimised solution2.Optimised solution with me in the team3. WF optimisation

Still unable to upload files to the community... so this is my wf: https://github.com/dsmdavid/Alteryx-Weekly-Challenge/blob/master/submitted/sub_Challenge%23111/solve...

Highlighted
Alteryx Partner
Spoiler

I tried the brute force method but Alteryx said nope! the duplication was causing 20GB of data before even reaching the final append. So, I opted for finding out how to use the optimisation tool as others did. Specifically I used @jamielaird's example and his workflow.

685 was the number!
Highlighted
Alteryx Certified Partner

My solution. It iook some time to figure out how to configure the Optimization tool ...

Spoiler
Alteryx Certified Partner

Very nice way to learn optimisation
Although I still find it challenging what to do if I wanted to optimise based on outcome variables

Fun to see that I still had tackled 11 challenges at that point, so I guess I'm catching up

Spoiler
Highlighted
Alteryx Partner

Highlighted
Alteryx Partner

First time using the Optimisation tool Thanks @PhilipMannering for the excellent blog on it

Spoiler

Highlighted
Alteryx

I've been a fan of the optimization tool since the Knapsack challenge (which for me was last week) so that was my first choice here. Of course I got 685.

Spoiler
I first tried this by minimizing rank. Then I went back to the problem and realized we were trying to maximize games won and then got 685.
Highlighted
Quasar

Workflow:

Spoiler

Results:

Spoiler

Highlighted
Asteroid

Optimization Solution attached.

Spoiler
Highlighted
Alteryx Partner

Can finally attach files, although cannot edit my previous reply