alteryx Community

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

## Challenge #344: World Cup Sweepstakes (Part 1)

11 - Bolide
Spoiler

A good challenge for practicing random functionality in Alteryx

10 - Fireball

344

8 - Asteroid
Spoiler
8 - Asteroid

Here it Goes !

11 - Bolide

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

11 - Bolide
Spoiler

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

11 - Bolide

My take on a solution

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

10 - Fireball

Here's my solution, fun challenge!

Spoiler

11 - Bolide
Spoiler