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