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

Inactive User
Not applicable
Spoiler
Solved using Text to Columns, DateTime Parse, Formula(using Replace to remove quotes) and select tool.
MaryCastillo
5 - Atom

I used text to columns, data cleanse, and date conversion.

 

Spoiler
Capture.PNG
Fei
6 - Meteoroid
Spoiler
2 Fei's Solution.PNG
Sihlex1
7 - Meteor

This is how I arrived at the solution.

 

Great Challange!!

 

 

mheinze
Alteryx
Alteryx

Text to Columns, Formula and DateParse.

MikeHinz
8 - Asteroid
Spoiler
2.PNG

I liked working on this one as its a quick parsing activity

leona0409
8 - Asteroid

Looking at the solution now, I think I could've combined two of the tools I used with one. I learned about a new function too!

mbogusz
9 - Comet
Spoiler
Challege#2_solution_mbogusz.png
yashwanth522
7 - Meteor

Awesome!! This is great way to learn alteryx.

Learnt to write formals to parse the date and remove delimeters.

Nic_Morales
Alteryx
Alteryx

First weekly challenge! Solution attached.