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.
The Alteryx Certification page will be going under maintenance on Monday August 22nd, from 9:45 AM MT to 12:45 PM MT. During this time the certifications will not be accessible. Please plan accordingly.

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

Jeremy
8 - Asteroid

I had the same issues with the solution, Tony, so I ignored the solution.  This may be another one they need to amend after publishing it.

KarenYL
8 - Asteroid
Spoiler
Screenshot 2022-05-16 142234.png

amacisaac
Alteryx
Alteryx

My solution. 

Andy MacIsaac
Ncardenas
8 - Asteroid

Great Challenge! I opted to use a Regex_Match, Unique, and Join in order to appoint those cities' missing states as mentioned.

Spoiler
Ncajamarca_0-1652742847891.png

 

 

Spoiler
HarleyBarnes_Quantium_0-1652750687714.png

 

Quick and easy one in 6 steps.

KaneG
Alteryx Alumni (Retired)

There's a little trick to this one. New York City is not in the answer but should be giving 48 Cities. NYC has 5 teams but does not span the 5 leagues (NBA x 2, NHL x 2, MLB).

 

Spoiler
It's all in that CountDistinct rather than Count

KaneG_0-1652752496612.png

 

TurboToad
8 - Asteroid

Good challenge! Ended up with 48 vs 47 results. Reworked the output as well. 

 

Spoiler
TurboToad_0-1652753635088.png

 


 

ahsanaali
8 - Asteroid

Here we go. Understanding the ask is 50% of the solution.

Qiu
19 - Altair
19 - Altair

I also have 48 records as output.
" do not have a team from all 5 leagues." maybe should be interpretted as at least one team from the five leagues.

Spoiler
challenge_319.PNG
amit_limbasia
6 - Meteoroid

Spoiler : Solution attached