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
SOLVED

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

kat
12 - Quasar
Spoiler
Challenge #125.PNG
Prab
7 - Meteor

Solution attached.

 

Spoiler
125.PNG
ckings
7 - Meteor

#goals

Spoiler
wk125.PNG
JimmyG
Alteryx Alumni (Retired)

Here is the answer I showed at Inspire.

 

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

CharlieS
17 - Castor
17 - Castor
 
Aster
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

 

 

 

 

JimmyG
Alteryx Alumni (Retired)

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

 

community_post.png

Aster
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!

Beastmode314
6 - Meteoroid

my solution

estherb47
15 - Aurora
15 - Aurora

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