community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

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

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.

A very welcome distraction - thank you :)

 

About 6 mins...

 

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

 

 

Spoiler
Regex is becoming my fave tool...

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

A solution has been posted

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

5:49

Nice quick exercise - thank you!

 

 

Alteryx Certified Partner

3:23

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
Quasar

4 minutes!

Spoiler
Spoilerimage.png
Alteryx Certified Partner

I really like these...under 5 mins

 

Spoiler
Weekly Challenge 31.png
Alteryx Certified Partner

Solution attached