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.
2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

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

martin-krejci
6 - Meteoroid
Spoiler
martinkrejci_0-1652892328362.png

 

Thorntonb
6 - Meteoroid

my solution. i think the solution is incorrect New York has 5 teams but not 1 from each league 

ravikumar060987
6 - Meteoroid

Please check my result:

brandongresl
5 - Atom

First attempt at a weekly challenge.

njusko
6 - Meteoroid
Spoiler
njusko_0-1652903633217.png

 

There's a few things that appear to be incorrect with this exercise. As noted elsewhere, "Bronx" is not a city, so I had to add a step to change "Bronx" to "New York City". Also, the example output doesn't appear to be capturing all the cities that do not have all 5 leagues. As a couple spot-check examples, "Atlanta" does not have all 5 leagues (has only 3: NBA, NFL, MLB), but is not shown in the example output; and, New York City does not have all 5 leagues (has only 4: NBA, NHL, MLB, MLS).

 

This was an interesting challenge nonetheless, thanks!

lucysinclair62
7 - Meteor

Great Challenge, my solution is below! I managed to do most of it but wasn't sure how to add the missing states to the city.

I'm new to alteryx so this was fun to try to figure out! :)

 

Spoiler
 

lucysinclair62_0-1652946093671.png

 

josh_dykstra
8 - Asteroid

done!

Spoiler
josh_dykstra_0-1652954328679.png

 

AlexEntz
8 - Asteroid

I really liked this challenge but I think my Workflow got a little bit out of hand, but well, it did the job!

 

Btw: The output does not contain NYC even though it should :)

 

Spoiler
AlexEntz_0-1652961358754.png

 

JamesCharnley
8 - Asteroid
Spoiler
JamesCharnley_0-1652965037755.png

 

Always enjoy a sports challenge

MY Solution for Challenge 319