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

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)

tristank
11 - Bolide

Great challenge! Looking at how others have approached it I think I brought in extra tools because I didn't consider that we can join on position and instead generated ranks to join on. Nevertheless a great lesson and something I will remember for next time.

 

Spoiler
Screenshot 2023-07-11 102749.png

 

Carolyn
12 - Quasar
12 - Quasar

Completed! As others commented, I missed the "make sure each person gets 1 of the top 5 teams" so I had to fix that

Spoiler
2023-07-28 11_36_02-Alteryx Designer x64 - challenge_344_start_file.yxmd_.png

Tgigs
8 - Asteroid

My solution attached.

 

Use R for the randomization since I am not familiar with macros. Need to review other solutions to understand how Alteryx macros work.

mithily
8 - Asteroid
Spoiler
easy with the logic that the recordid can also match the team rank
DaisukeTsuchiya
13 - Pulsar
Spoiler
スクリーンショット 2023-08-18 180631.jpg

Sunny_Anand
6 - Meteoroid

My Solution

gawa
16 - Nebula
16 - Nebula

Done

anabelvelazque
8 - Asteroid

Hi! Here is my take :-) 

Spoiler
Screenshot 2023-09-05 111331.png
kaiserj
8 - Asteroid

😀

MatthewGrant12
8 - Asteroid

Solution: