We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. 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 #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
17 - Castor
Spoiler
Luke_C_0-1650896585176.png

 

AkimasaKajitani
17 - Castor
17 - Castor

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
20 - Arcturus
Spoiler
binuacs_0-1650902176086.png

 

TonyAndriani
9 - Comet

Here's my solution

Spoiler
TonyAndriani_0-1650905340760.png

 

 

TurboToad
9 - Comet

Fun data parse challenge!

Spoiler
TurboToad_0-1650909266939.png

 


 

Hsolmaz
7 - Meteor

Fun one. Thank you.