Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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)

tsand22
8 - Asteroid

Our solution

himanshu_v_17
8 - Asteroid

here is the solution

lucascs
8 - Asteroid

solved

m_v
8 - Asteroid

Solution attached.

nSpire
9 - Comet
Spoiler
nSpire_0-1678865342712.png

 

mdm
8 - Asteroid
Spoiler
mdm_1-1680938598502.png

 


 

Here's my solution.

Firstly IDs are generated for each entrant. RandInt function is used to generate random integer as Selection Sequence for each team.

The teams are separated into two groups (top 5 ranked teams and Other than top 5 ranked teams ).

 

Round 1: Top 5 ranked teams

After the teams are sorted by the Selection Sequence, the IDs are generated to join the entrants by Join tool.

 

Round 2: Other than top 5 ranked teams

After sorted the teams by the selection sequence, the teams are split into 5 groups by using Tile tool. Then the rows are filtered out if  [Tile_SequenceNum] is greater than 5 (Each entrant take one team in Round 1. Thus, only 5 teams need to be taken in this round)

The teams are joined to entrants by using Join tool.

 

Lastly, the results of Round 1 and 2 are combined by using Union tool. That's it.

RobbieA
8 - Asteroid

My Solution to 344:

Shifty
12 - Quasar

Yes! 🏈

 

Spoiler
Shifty_0-1681746845834.png

 

gaoa
11 - Bolide
Spoiler
 
Brian32
8 - Asteroid

Challenge Solution:

Spoiler

Brian32_0-1682341894890.png