Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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