Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #2: Preparing Delimited Data

Highlighted
5 - Atom

clipboard_image_0.png

Highlighted
7 - Meteor

Done! 

Highlighted
8 - Asteroid
Spoiler
I started by removing all punctuation save for the hyphens in the dates, then converting the date format and then using a select tool to clean-up and rename the data challenge_2_solution_BL.png
Spoiler
 
Highlighted
Moderator
Moderator

Regex!

 

Spoiler
clipboard_image_0.png
Sophia Fraticelli
Premium Support Advisor
Alteryx, Inc.
Highlighted
7 - Meteor
Spoiler
Challenge2_Preparing Delimited Data.jpg
Highlighted
7 - Meteor
 
Highlighted
Alteryx
Alteryx

My Solution

Spoiler
Weekly Challenge_2_AJM.png
Highlighted
5 - Atom

Just joined the community and solved my first weekly challenge

Highlighted
7 - Meteor

 

Spoiler
clipboard_image_0.png

 

 

 

This is my solution using Reg Ex (this is the first time i use reg ex tool)

Highlighted
8 - Asteroid

My Solution: