Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #2: Preparing Delimited Data

Highlighted
 
Highlighted
Alteryx Certified Partner
Spoiler
edgarl_0-1579576837490.png
Highlighted
Meteoroid

My shot

Spoiler
Per_0-1579604379736.png
Highlighted
Asteroid

Text to columns based on the comma, convert the date, and rename columns.

Highlighted
Atom

Solution

 

 

Spoiler

First text-to-column to separate by comma delimiter, then data cleansing to remove extraneous punctuation, then DateTime to convert into the proper date format and finally a Select tool to rename the columns

 Mitrea32_1-1579634666654.png

 

Highlighted
Asteroid
 
Highlighted
Spoiler
Solved this problem! See below with annotations:
rachelglascock_0-1579810694578.png
Highlighted
Meteor

Challenge 2 completed

Highlighted
Meteor

Complete

Highlighted

My solution