Challenge #319: Sports Spots

[martin-krejci]

Spoiler

[Thorntonb]

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

[ravikumar060987]

Please check my result:

[brandongresl]

First attempt at a weekly challenge.

[njusko]

Spoiler

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]

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

[josh_dykstra]

done!

Spoiler

[AlexEntz]

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

[JamesCharnley]

Spoiler

Always enjoy a sports challenge

[rahulchetwani2022]

MY Solution for Challenge 319