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 #2: Preparing Delimited Data

ambica
5 - Atom

clipboard_image_0.png

ken_yap_au
8 - Asteroid

Done! 

Billigans
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
 
SophiaF
Alteryx
Alteryx

Regex!

 

Spoiler
clipboard_image_0.png
Sophia Fraticelli
Senior Solutions Architect
Alteryx, Inc.
Inactive User
Not applicable
Spoiler
Challenge2_Preparing Delimited Data.jpg
Francoisdup
7 - Meteor
 
amacisaac
Alteryx
Alteryx

My Solution

Spoiler
Weekly Challenge_2_AJM.png
Andy MacIsaac
shirishag
5 - Atom

Just joined the community and solved my first weekly challenge

Ivanmt01
7 - Meteor

 

Spoiler
clipboard_image_0.png

 

 

 

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

sachinw
8 - Asteroid

My Solution: