Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
SOLVED

Challenge #125: US Grand Prix Lap 1 - Data Prep

Highlighted
12 - Quasar
Spoiler
Challenge #125.PNG
Highlighted
7 - Meteor

Solution attached.

 

Spoiler
125.PNG
Highlighted
Alteryx Certified Partner

#goals

Spoiler
wk125.PNG
Highlighted
Alteryx
Alteryx

Here is the answer I showed at Inspire.

 

Great job, everyone, It's awesome to see so many people timing themselves!

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
 
Highlighted
7 - Meteor
Spoiler
weekly challenge 125.png

My solution here, took more than 12 min though...

A quick note: I thought the Date Time tool has a droplist for you to select the field to parse? I cannot find the droplist button and had to type in the field name manually. With 2018.2

 

 

 

 

Highlighted
Alteryx
Alteryx

@Aster You should definitely have a drop down list from which to chose. 

 

community_post.png

Highlighted
7 - Meteor

Thank you Jimmy. I was using remote desktop last week and now I have confirmed the droplist is there.

Perhaps something wrong with the remote desktop causes the button not to render. Thanks anyway!

Highlighted
6 - Meteoroid

my solution

Highlighted
14 - Magnetar
14 - Magnetar

Definitely not as much fun as watching it live. Took me under 3 minutes.

Spoiler
Used the Multi-Field formula tool to convert the date strings into actual dates, and change the data types, simultaneously.
image.png