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

shwetas92
5 - Atom

My take on challenge 2!

dicky5150
8 - Asteroid

Starting my week off with another challenge, I'm planning on just chugging through them all in order to learn something new from each one, still very much a newbie !

Data_User88
8 - Asteroid

This is my first challenge completed. :-)

dicky5150
8 - Asteroid

Great way to learn the tool too !!

juansagasta
7 - Meteor
Spoiler
Spoiler.PNG
nikolaskardasis
8 - Asteroid
Spoiler
solution.PNG
dvsrtns
7 - Meteor

And that's two.

 

Spoiler
Capture.PNG
atrozz
8 - Asteroid

Hello all, im again. Nice excercise to practice easy parse in Alteryx.

Spoiler
First, im use text to column tool to obtain the 3 fields, using a ',' delimiter. Then, im cleasing the punctuations in all fields, this isnt a problem with the date field because datetime tool is possible to custom a date format (ddMon.yy in this excercise); finally only select the fields. Good luck!!!
Challenge 2.png
zoingz
6 - Meteoroid

Reiterating the solution from my old profile with userid : ajsh

 

 

Luca
8 - Asteroid

My solution:

 

Spoiler
Challenge2.JPG