Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #344: World Cup Sweepstakes (Part 1)

olga_strubbe
10 - Fireball
Spoiler
olga_strubbe_0-1667837886245.png

 

A good challenge for practicing random functionality in Alteryx

rmassambane
10 - Fireball

344

mmotte628
8 - Asteroid
Spoiler
Screenshot 2022-11-07 112442.png
saiirangam
8 - Asteroid

Here it Goes !

mmontgomery
10 - Fireball

Probably overdid it to ensure randomness but did the following steps:

1. Count entrants and bucket them into two categories (top N and non Top N) to ensure if 6 people, they'd get randomly one of top 6 teams, etc. If 5 people, then top 5 teams and remaining teams randomly assigned.

2. Random ID then sort to ensure random order each run then did floor calc to ensure same number of teams per person then grouped them together

Spoiler
mmontgomery_0-1667841715908.png

 

ahsanaali
11 - Bolide
Spoiler
ahsanaali_0-1667842328531.png

 

acarter881
12 - Quasar

Here's my solution. This is quite a difficult challenge. However, I was able to make a workflow that is dynamic. Nothing is hard coded; it will assign the top ranked teams (based on how many entrants there are) then randomly assign the non-top ranked teams. I remember the main technique (i.e., random number generator) from a previous problem I encountered. I also included a message that returns an error if the number of entrants is greater than 32 (decided to use the Message tool instead of the Test tool).

Spoiler
acarter881_0-1667843450196.png

 

 

Clifford_Coon
11 - Bolide

My take on a solution

Spoiler
Replicate # Teams / # Entrants for each entrant, then randomize and assign by ranking by group 
challenge_344.jpg

TurboToad
9 - Comet

Here's my solution, fun challenge!

Spoiler
TurboToad_1-1667857707070.png

 

braveraj
10 - Fireball
Spoiler
braveraj_0-1667860781637.png