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 #349: Analyze the World Cup Event

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found here.image_349.png

 

To solve this week’s challenge, use Designer Desktop.

 

This challenge comes to us from @Pawel_Paleczny  Thank you for your contribution.

 

The FIFA World Cup is currently taking place in Qatar. Pavel would like to perform analyses on the event.

 

The first dataset contains information about the stadiums: stadium name, city, capacity, latitude, and longitude.

The second dataset contains information about the events: match number, round, dates, location, which teams are playing, and the group or phase.

 

For this challenge:
1. Assuming that each match will have a full audience, find the top 10 teams that could have the largest audience in the group stage.
2. Find the three cities with the most World Cup matches.

Flo_P
9 - Comet

Quick and dirty

ggruccio
ACE Emeritus
ACE Emeritus

Fun quick challenge!

Spoiler
ggruccio_0-1670851901731.png

 

benjimoser
9 - Comet

My solution using RegEx Parse and the Arrange Tool.

 

Spoiler
benjimoser_0-1670852132033.png

 

 

binuacs
21 - Polaris
Spoiler
binuacs_0-1670853640946.png

 

alexnajm
17 - Castor
17 - Castor

Just got back from the World Cup - what a tournament!

Spoiler
Challenge 349.PNG
sgarbev
7 - Meteor
Spoiler
sgarbev_0-1670855947989.png

 

balajilolla1
8 - Asteroid
Spoiler
Solution Attached

balajilolla1_0-1670856128985.png

 

ahsanaali
11 - Bolide
Spoiler
ahsanaali_0-1670857671589.png

 

JBarr
8 - Asteroid

Done.