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

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: