Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

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 #167: Grand Prix 2019

PeterGoldey
ボリード

thx!

 

angelina4248
メテオロイド

Just started learning Alteryx for few days.

Brian_Stoffel
アステロイド
 
bnelly1987
アステロイド

Here is mine! Looks a lot like everyone elses. That Driver Standings was there just to throw us off.

スポイラ
Solution-Challenge 167.PNG
john_miller9
ボリード

I had a lot of fun with this one.  I've just started to complete these challenges a few days ago and took this beginner challenge and applied some more advanced techniques from older challenges to test these newly acquired skills.  For example, the record for Ray Reed was missing a value in the dob field so I used the included url to download this wikipedia page and leveraged regex to parse out his birth date and join back to the dataset.  In the end, it didn't matter as he never was a Grand Prix champion, but it was fun to test myself by building a complete dataset that could be used to answer additional questions with full confidence that all data points are being considered.

 

In any event, my solution is below!

 

スポイラ
challenge_167.png
ELPC
アステロイド

Is there anyway to download the starting data if I have an older version of Alteryx (2018.4)?  

Greg_Murray
クエーサー

My solution 

スポイラ
Capture.PNG
klyuka
アステロイド

However ideal solution should count not the last race of the year, but the race when one driver becomes unstoppable (no need to wait end of season).

ianwi
Alteryx Alumni (Retired)

Hi @ELPC,

 

You should see a dialogue box when you attempt to open the workflow. Just respond "Yes" and it will open up!

 

workflow compatability.PNG

kat
クエーサー
スポイラ
Challenge #167.PNG