Challenge #344: World Cup Sweepstakes (Part 1)

[olga_strubbe]

スポイラ

A good challenge for practicing random functionality in Alteryx

[rmassambane]

344

[mikemotter]

スポイラ

[saiirangam]

Here it Goes !

[mmontgomery]

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

スポイラ

[ahsanaali]

スポイラ

[acarter881]

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

スポイラ

[Clifford_Coon]

My take on a solution

スポイラ

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

 

[TurboToad]

Here's my solution, fun challenge!

スポイラ

[braveraj]

スポイラ