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.
2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

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 #316: Blowing in the Wind - Part 1

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found here.image316.png

 

This week is part 1 of the challenge “Blowing in the wind”. 

 

On December 30, 2021, a windstorm moved through some of the Front Range counties of Colorado. One Alteryx associate found herself driving back home in the storm and being “blown in the wind”. And she got the idea for a two parts challenge.

 

The dataset comes from the US National Weather Service, and it recorded the maximum wind speeds at several locations.

 

Use the dataset to:
- Find the county, location with the maximum highest wind speed at a given time
- Rank the counties by average highest wind speed
- Determine if the average highest wind speeds were before Noon or after Noon

 

First, prepare and the parse the provided input string into separate columns.

 

Note: you only need to parse up to the time.

Luke_C
16 - Nebula
Spoiler
Luke_C_0-1650896585176.png

 

AkimasaKajitani
15 - Aurora
15 - Aurora

My solution.

 

Spoiler
AkimasaKajitani_1-1650898173326.png

 


 

balajilolla1
8 - Asteroid
Spoiler
Solution Attached

balajilolla1_0-1650898940007.png

 

Blake
12 - Quasar

I went outside to see this crazy wind storm everyone was talking about...

 

Spoiler
I was blown away!
Spoiler
316WC.png

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
316.png
binuacs
15 - Aurora
Spoiler
binuacs_0-1650902176086.png

 

TonyAndriani
8 - Asteroid

Here's my solution

Spoiler
TonyAndriani_0-1650905340760.png

 

 

TurboToad
7 - Meteor

Fun data parse challenge!

Spoiler
TurboToad_0-1650909266939.png

 


 

Hsolmaz
7 - Meteor

Fun one. Thank you.