Free Trial

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

robbie0sc
7 - Meteor
Spoiler
robbie0sc_0-1673956645536.png

 

Solved!

mirandamcgill
5 - Atom
Spoiler
mirandamcgill_0-1673956672228.png

 

tomrob
7 - Meteor
Spoiler
 

tomrob_0-1673956663291.png

 

MattBrandVB
5 - Atom

First one Complete

 

task number 2.PNG

Spoiler
 
Shreya_p
7 - Meteor
Spoiler

Shreya_p_2-1673956745766.png

 

Antlansana
5 - Atom

 

Spoiler
Spoiler
Antlansana_1-1673956759178.png

 

Gem_VisitBritain_0456
6 - Meteoroid
Spoiler
Gem_VisitBritain_0456_0-1673956790523.png

 

crukesh
5 - Atom

Use Text to Column Tool filtered by , --> Remove special characters with Data Cleaning tool -->Use Date Time tool and modify the date according to input --> Use Select tool to customize the column names and select the required columns. 

corleyr
7 - Meteor

My solution.

dakurz
6 - Meteoroid

Solution attached