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

TonyA
Alteryx Alumni (Retired)

Here's my solution. I think it could do with some trimming, but it works.

mbogusz
9 - Comet

I didn't use the Driver Standings input data at all, but still came to the same result.  It took an hour compared to the 10 minutes or so for the LIVE Grand Prix. 

Spoiler
Challege 167 Spoiler.png 

 

mbogusz
9 - Comet

Nice job @TonyA.  I didn't have to use the Driver Standings input either.

 

Well done @john_miller9. Nice use of the Download tool to query Wikipedia for extra credit.

 

Agreed @bnelly1987.  Useless Driver Standings data.

jamielaird
14 - Magnetar

Here's my solution

 

Spoiler
Screenshot 2019-06-24 at 20.09.20.png
leena_suva
6 - Meteoroid
Spoiler
Spoiler Alert #167.JPG
vkozub
Alteryx Alumni (Retired)
 
SharonNkn
6 - Meteoroid

Here's mine!

I did not use one of the input tables...

 

Spoiler
キャプチャ.PNG
PaceParillo
7 - Meteor
Spoiler
challene167.PNG
mddreeves
6 - Meteoroid

Question for you.  I have only been using Alteryx for a few weeks....just passed the Core exam last night.  When you build workflows like this, what is your technique for knowing which fields to de-select in your joins?  Do you de-select as you go, or once you get to the next step and verify what you need, do you go back and de-select fields in the previous step to streamline?

virajdeshpande
7 - Meteor

Tried a very simple approach without any complicated operations/functions.

Suggestions and criticism always welcome!

 

Capture.PNG