Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
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.

Challenge #31: Alteryx '16 Grand Prix (Race 2, L1)

Highlighted
Alteryx Alumni (Retired)

I hope everyone is enjoying the Grand Prix series, last week’s (challenge #30) solution is posted HERE.

 

Here is the Scenario for this lap:  With Inspire being held in beautiful San Diego, I'm planning on taking Friday off and trying out some of the world class surfing! Since it is summer, and I'm definitely a novice, I'd like to visit the surf sites in San Diego County that are appropriate for beginners and summer surfing season. Luckily, I found some datasets on the internet that provide this information.

 

The objective is to:  Join the site characteristics to the site location data and identify the four locations that are appropriate for a beginner skill level surfing in the summer season.

 

*Remember to time yourself, contestants only had about tem minutes per lap.

Highlighted
16 - Nebula
16 - Nebula

A very welcome distraction - thank you 🙂

 

About 6 mins...

 

Spoiler
2016-06-27_21-45-26.jpg
Highlighted
8 - Asteroid

 

 

Spoiler
Regex is becoming my fave tool...

Capture.JPG
Ooops - forgot about Select but the time was over 10 min. anyway.
Highlighted
Alteryx
Alteryx

A solution has been posted

Spoiler
2016-07-05 15_05_47-Alteryx Designer x64 BETA - Surf City - Race2Lap1_Solution.yxmd.png
Tara McCoy
Highlighted
16 - Nebula
16 - Nebula

5:49

Nice quick exercise - thank you!

 

 

Highlighted
Alteryx Certified Partner

3:23

Highlighted
14 - Magnetar
14 - Magnetar

My solution!

Spoiler
My first instinct was to do a TrimRight or Replace for the county name in Surf Site Locations data... but I am very quickly becoming a fan of the flexibility of RegEx! Who knew?? By using RegEx, this would work for data that contained multiple counties, as long as they were separated with a "-" from the surf site. I like it...
WeeklyChallenge31.JPG
Highlighted
14 - Magnetar
14 - Magnetar

4 minutes!

Spoiler
Spoilerimage.png
Highlighted
Alteryx Certified Partner

I really like these...under 5 mins

 

Spoiler
Weekly Challenge 31.png
Highlighted
Alteryx Certified Partner

Solution attached