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

ARussell34
8 - Asteroid

I have 47 cities that don't have all 5 "big leagues", 10 cities that do.

TKoep
7 - Meteor

solution

 

I believe there should be 48 cities - New York doesn't have a MLS or NFL team.

TKoep_0-1663954383663.png

 

SylwiaDragon
8 - Asteroid

done

peterr_h
8 - Asteroid

Think that New York City may be missing from the Output, as there's no NFL team there yet it's not included?

martinding
13 - Pulsar

A very good use case for the "Find and Replace" Tool!

Spoiler
319.png

nandagaikwad03
8 - Asteroid
Spoiler
Challenge_319_Workflow.png

 Loved the Sports theme :)

peterr_h
8 - Asteroid

I got 47 too - my reasoning was that it has 2 Ice Hockey teams, so the given solution (sorting by team names) doesn't find distinct leagues. However, I'm in agreement with your answer!

Supergiant
8 - Asteroid
Spoiler
Supergiant_0-1665668903087.png
Turley93
8 - Asteroid

Solution

jflanigan
8 - Asteroid

Similar to others, I used a countdistinct on Leagues and came up with 48 (vs solution of 47) teams.  NYC is the difference with 5 teams but not 5 leagues.

Spoiler
jflanigan_0-1666207751372.png