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)

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
14 - Magnetar
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: