Cloud Quests

AYXAcademy · ‎07-23-2025

Hi Community,

We posted the solution JSON file to Cloud Quest #38. 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!

Download the provided JSON file containing your starting data and workflow files.
Upload Start Cloud Quest 39.json file to your Analytics Cloud library.
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:

On December 30, 2021, a powerful windstorm swept across parts of Colorado’s Front Range. This dataset provided by the U.S. National Weather Service captured maximum wind speeds recorded at various locations throughout that day.

Your task is to analyze the data and answer the following:

Identify the county and location with the overall highest recorded wind speed.
Rank all counties by their average highest wind speed.
Determine whether the average highest wind speeds occurred before noon or after noon.

Hint:

Begin by parsing the provided input into separate columns up to the time component in the string.
The RegEx character group [[:punct:]] can be used to identify and remove all punctuation from a string.

Data Source: US National Weather Service

Image generated by Google Gemeni, July 22, 2025, OpenAI, https://gemeni.google.com.

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 | Download Solution File

Carolyn · ‎07-23-2025

Solved! Only 1 more until the next badge unlocks!

Spoiler

2025-07-23 10_05_50-Cloud_Quest_39_Carolyn _ Workflows.png

Qiu · ‎07-23-2025

@Carolyn
You are very fast 😁

Qiu · ‎07-23-2025

A fun one 😁

Spoiler

RWvanLeeuwen · ‎07-23-2025

Nice Excel challenge. Would love to work with the spatial capabilities in the AYX Cloud

Spoiler

as it is space delimited, and does not include tabs, I edited these rows by inserting an extra space to make the parsing function

I almost cleaned the whole dataset, but as dateparsing and spatial analytics are outside of scope, I'd just leave it at this.

as it is space delimited, and does not include tabs, I edited these rows by inserting an extra space to make the parsing functionI almost cleaned the whole dataset, but as dateparsing and spatial analytics are outside of scope, I'd just leave it at this.