alteryx Community

# 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.

## Challenge #319: Sports Spots

8 - Asteroid

learned how to concatenate using the new line (\n) separator in this challenge!

ACE Emeritus

Most markets don't have all 5!

Spoiler

8 - Asteroid

Solved!

8 - Asteroid

Toronto were a NFL team away from having all 5 :)

Spoiler

8 - Asteroid
Spoiler

Solved

Alteryx Alumni (Retired)
Spoiler
meandered around, but think my output is an improvement on the same one :P

awesome challenge!

8 - Asteroid

Thank you for the challenge!

I have only a consideration about the given solution.

The last filter that considers Count < 5 do not work in all cases, because there are cities that have more than one team for the same league.

For example, New York City does not have MLS and NFL, so it should be listed at the answer but it is not because it has 1 MLB, 2 NBA and 2 NHL (>= 5).

12 - Quasar

Here is my solution!

Spoiler

8 - Asteroid
Spoiler

8 - Asteroid

Thanks for the challenge! Here's my solution: