topic Re: Challenge #31: Alteryx '16 Grand Prix (Race 2, L1) in Weekly Challenges

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

GeneR — Tue, 13 Sep 2022 16:55:33 GMT

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.

Re: Weekly Exercise #31: Alteryx Grand Prix Race 2 Lap1 (Intermediate)

jdunkerley79 — Mon, 27 Jun 2016 20:48:21 GMT

A very welcome distraction - thank you :)

About 6 mins...

Re: Weekly Exercise #31: Alteryx Grand Prix Race 2 Lap1 (Intermediate)

markp201 — Wed, 29 Jun 2016 18:09:16 GMT

Regex is becoming my fave tool...

Ooops - forgot about Select but the time was over 10 min. anyway.

Re: Weekly Exercise #31: Alteryx Grand Prix Race 2 Lap1 (Intermediate)

TaraM — Tue, 05 Jul 2016 21:08:07 GMT

A solution has been posted

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

SeanAdams — Wed, 29 Mar 2017 07:44:54 GMT

5:49

Nice quick exercise - thank you!

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

Garrett — Mon, 03 Apr 2017 15:51:17 GMT

3:23

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

NicoleJohnson — Wed, 12 Apr 2017 20:52:44 GMT

My solution!

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

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

estherb47 — Mon, 01 May 2017 04:01:12 GMT

4 minutes!

Spoiler

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

LordNeilLord — Tue, 23 May 2017 17:59:56 GMT

I really like these...under 5 mins

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

nick_ceneviva — Thu, 20 Jul 2017 17:51:05 GMT

Solution attached

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

Laurap1228 — Mon, 24 Jul 2017 22:49:09 GMT

Fitting that did this challenge on a flight from London to San Diego!

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

Lorna_Eden — Wed, 26 Jul 2017 10:44:15 GMT

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

jamielaird — Sat, 09 Sep 2017 20:32:27 GMT

Done in 6.5 mins.

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

patrick_digan — Tue, 19 Sep 2017 14:11:30 GMT

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

Natasha — Sat, 28 Oct 2017 11:55:47 GMT

This was quick and fun

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

JoshKushner — Tue, 07 Nov 2017 14:41:42 GMT

New Record! 3 min. to finish.

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

Waynemk — Thu, 30 Nov 2017 23:49:51 GMT

Gotta love the fast/simple(r) ones

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

samN — Fri, 01 Dec 2017 00:11:32 GMT

About 6 Min

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

ggruccio — Sun, 03 Dec 2017 21:39:16 GMT

Finished quickly!

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

philipmannering — Tue, 12 Dec 2017 17:38:17 GMT

Solution attached.