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

Kenda
16 - Nebula
16 - Nebula
Spoiler
Kenda_0-1652721501455.png

 

FloraF
Alteryx
Alteryx

Solved!

 

FloraF_0-1652721616618.png

 

TonyAndriani
9 - Comet

Several problems with the provided solution. As @Reesetrain2 noted, Bronx is a borough of New York City. Also, the solution doesn't account for cities that have more than one team in the same league. So New York should be in the list. Excluding the Bronx, it has no NFL or MLS teams but does have two NHL and NBA teams. The question asks how many leagues are represented. The solutions shows a count of 5, should be 3.

Spoiler
TonyAndriani_0-1652721898672.png

 

dbrownsc
7 - Meteor
Spoiler
Spoiler

dbrownsc_0-1652722483142.png

 

 

patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1652722490279.png

I ended up with 48 due to NY Ctiy

Powerhouse_21
10 - Fireball

I created 2 outputs. One has the 48 cities, but outlines each of the Team types and names them. the other has 101 records but that's due to each of the cities having multiple teams. I also kept the Burroughs of NYC separated. 

 

Spoiler
Powerhouse_21_3-1652732693254.png

 


 


 


 

 

 

phottovy
13 - Pulsar
13 - Pulsar

My solution:

Spoiler
319.png
JereJussila
8 - Asteroid
Spoiler
JereJussila_0-1652727138881.png

 

New York City should be included in the solution output

ejjacobs4
5 - Atom

I used my first macro, that was fun, Also noticed solution was wrong, because New York City has 5 teams but only 3 leagues. I made sure to include the extra teams in the final data, but only count them as 3 unique leagues

 

Spoiler
macro.PNGworkflow.PNG
Jeremy
8 - Asteroid

Attached.  Interesting challenge.  I had some issues with punctuation with the way I implemented this, so I have some replace tools that shouldn't have been necessary.