Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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 #16: Parsing Out the New-line Character

danicahui
8 - Asteroid
Spoiler
Challenge 16 2019-11-28.jpg
tiffany_chen
8 - Asteroid

Use of formula DateTimeParse.

Spoiler
2019-11-30_122222.png
OliverJ
7 - Meteor
 
ozdogand
8 - Asteroid

better late than never..

Spoiler
ozdogand_0-1575345363500.png
jfone
8 - Asteroid
 
Crusnik86
5 - Atom
 
 
StephaneP
Alteryx
Alteryx
Spoiler
Done ! 🙂
Stéphane Portier
Sales Engineer
Alteryx
Hjardine
8 - Asteroid
Spoiler
Hjardine_1-1576091173474.png

Cleansed the data to remove embedded line-feed character, used date time tool to convert date to proper format, then selected to rename columns. 

Ivyin702
7 - Meteor

Please find the attached solution file. 

sonyakasenkramer
8 - Asteroid
Spoiler
sonyakasenkramer_0-1576174818610.png