Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #31: Alteryx '16 Grand Prix (Race 2, L1)

rslopez2
8 - Asteroid

5:56

 

Spoiler
RL_Wk31.png
danicahui
8 - Asteroid
Spoiler
Challenge 31 2019-11-29.jpg
sachinw
8 - Asteroid

My Solution:

SueDonim
8 - Asteroid

After struggling on the last few challenges, it is nice to have one that was so well behaved.  Cowabunga!

 

Spoiler
Process:
- Filtered out first two rows of Surf Site Characteristics
- Dynamic Rename to set field names
- RegEx Replace formula to remove " - San Diego County" from Surf Site Locations
- Join on Surf Site / Site
- Filter for "Beginner"
- Filter for "Summer"

MySolution.PNG
sonyakasenkramer
8 - Asteroid
Spoiler
sonyakasenkramer_0-1575402500562.png
ozdogand
8 - Asteroid

here you go..

Spoiler
ozdogand_0-1575403616367.png
Rags1982
10 - Fireball
 
rmassambane
10 - Fireball
 
nini
8 - Asteroid

My Solution:

Ladarthure
14 - Magnetar
14 - Magnetar

my solution