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

eshwar
5 - Atom
Spoiler
image.png
mikkel
5 - Atom
Spoiler
My solution

clipboard_image_0.png
Rags1982
10 - Fireball
 
saurabh307singh
8 - Asteroid

My Solution: 

Spoiler
image.png

 

Laszlo_D
8 - Asteroid

clipboard_image_0.png

shahryal
8 - Asteroid
Spoiler
Spoiler



clipboard_image_0.png

 

jaiswas1
7 - Meteor

Uploading the approach I have taken to solve the challenge.

Ray_Whyte
5 - Atom
Spoiler
Cleansed very small data set. removed punctuation.
chloe_donaldson
5 - Atom
Spoiler
We used the Text to Columns tool so that we could separate the commas this  removed the commas. Format date and remove columns that are no longer needed.
 clipboard_image_0.png
tony_beck
6 - Meteoroid
Spoiler
Using text to columns to sperate by commas, format data with select tool - remove unwanted columns - changed date type.