community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
SOLVED

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

Quasar
Spoiler
Challenge #125.PNG
Meteor

Solution attached.

 

Spoiler
125.PNG
Alteryx Certified Partner

#goals

Spoiler
wk125.PNG
Alteryx
Alteryx

Here is the answer I showed at Inspire.

 

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

Alteryx Certified Partner
 
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

 

 

 

 

Alteryx
Alteryx

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

 

community_post.png

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!

Meteoroid

my solution

Bolide

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