We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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
16 - Nebula
16 - Nebula

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
17 - Castor

solution attached

binuacs_0-1652715711109.png

 

dYoast
9 - Comet

Interesting results.

Spoiler
dYoast_0-1652716141501.png

 

Reesetrain2
8 - Asteroid

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