Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.
alteryx Community

# Weekly Challenge

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.

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

11 - Bolide

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...

8 - Asteroid
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!
16 - Nebula

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

Spoiler
11 - Bolide

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
11 - Bolide

15 - Aurora

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

Spoiler

Alteryx Alumni (Retired)

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

Workflow:

Spoiler

Results:

Spoiler

8 - Asteroid

Optimization Solution attached.

Spoiler
11 - Bolide

Can finally attach files, although cannot edit my previous reply