Cloud Quest #42: League Locations

[AYXAcademy]

 

Hi Community,

We posted the solution JSON file to Cloud Quest #41. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!

Let’s dive into this week's quest!

1. Download the provided ZIP file containing your starting data and workflow files.
2. Upload Start Cloud Quest 42.json to your Alteryx One library.
3. All necessary datasets are contained within Text Input tools in the workflow..

For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process.

 

Scenario:

Sports franchises in the US are valuable cultural assets, often tied to the identity of their cities. However, because of differing demographics, the NFL, NBA, MLB, MLS, and NHL do not always place teams in the same cities.

For this week’s quest, use the five provided datasets to find the cities that host a team from three or fewer leagues. Your output should list each city along with its teams and leagues.

Note: Some records are missing state values, but you can retrieve them from another dataset containing the same city.

Hint: A Cross Tab tool will be useful for reshaping your dataset for output.

Data sources:
https://en.wikipedia.org/wiki/List_of_Major_League_Soccer_stadiums
https://en.wikipedia.org/wiki/List_of_National_Hockey_League_arenas
https://en.wikipedia.org/wiki/List_of_current_National_Football_League_stadiums
https://en.wikipedia.org/wiki/List_of_National_Basketball_Association_arenas
https://en.wikipedia.org/wiki/List_of_current_Major_League_Baseball_stadiums

Image generated by Google Gemini, September 02, 2025.

 

 

Earn Cloud Quest badges:

After completing your quest, head back to your Analytics Cloud library:

• Download your workflow solution file.
• In your reply, attach both your JSON solution file and a screenshot of your workflow.
• Keep submitting—every solution gets you closer to earning more Cloud Quest badges!

 

Here’s to a successful quest!

- The Academy Team

Download Start File

[AkimasaKajitani]

My solution!

Spoiler

[RolandSchubert]

Spoiler

[alexnajm]

Done!

Spoiler

Watch out for New Orleans

[Qiu]

I have found a few discrepancies when comparing with the provided answer.

Spoiler

There "Space" in below two rows for "Location" is somehow different and can not be grouped. --> Manually modified.

According to Google, there is a Kansas City in Missouri (KCMO) and a separate Kansas City in Kansas (KCK), which straddle the state line and are two different cities with distinct governments. So we can not really judge  "Kansas City Chielfs" belongs to which state on by the data. 
It seems the answer provided categorized it to Kansas State, which should be Missouri. --> Manual update the input data.

There are specifial characters in the provided answer.

[Carolyn]

Solved!

Spoiler

[RWvanLeeuwen]

Here's my solution

Spoiler

[AYXAcademy]

Thank you @Qiu! The start and solution files have been updated. 

[Qiu]

@AYXAcademy 
Thank you very much for following up. 👍

[NaiLo]

Was confused that the BC lions weren't in the NFL until I learned there's a CFL 🙃

Spoiler