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 #319: Sports Spots

AYXAcademy
Alteryx
Alteryx

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

 

Sports franchises are not only valuable, but they often become integral to the identity of the cities they represent. These “big league” teams usually inhabit only the largest cities to ensure there are plenty of fans nearby to buy tickets and jerseys! The NFL, NBA, MLB, MLS, and NHL have different demographics and they don’t always inhabit the same cities.

 

For this week’s challenge, use the 5 datasets provided to find the cities that do not have a team from all 5 leagues.

 

Your output should list the teams and their leagues for those cities. Note that some of the city information is missing a state, but you can grab those missing values from another dataset that has the same city!

scoles0617
8 - Asteroid

My solution:

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_0-1652713476416.png

 

joelmiller66
9 - Comet

I think we need all the major sports on the list :)

 

Happy INSPIRE WEEK!!!!

319 meme.jpeg

Spoiler
 

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
R319.pngW319.png
binuacs
21 - Polaris

solution attached

binuacs_0-1652715711109.png

 

dYoast
11 - Bolide

Interesting results.

Spoiler
dYoast_0-1652716141501.png

 

Reesetrain2
9 - Comet
9 - Comet

All,

 

Spoiler
Pretty straight forward challenge, although I love the sports theme.
-1 Union
-1 Text to Column
-1 Data Cleansing
-1 Select
-1 Summation (I used a comma separator vice the new line for astetics)
-1 Filter
-1 Sort
Technically, the Bronx is a bureau of New York City, so really shouldn't be on the list..
Capture.PNG

balajilolla1
8 - Asteroid
Spoiler
Solution Attached

balajilolla1_0-1652720084276.png

 

smitj160
5 - Atom
Spoiler
Spoiler

smitj160_0-1652720659627.png