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

DE0413
8 - Asteroid

Late to the game, but attempting to complete the challenges without reviewing the solutions.  Attached is my solution.

 

Best wishes,

Denise

Phil_L57
7 - Meteor

Hi GeneR,

 

Used the data cleansing tool to clean the punctuation from the first 2 columns then used the following custom date format in a datetime tool:

'dd-Mon-yy'

 

Phil

 

LordNeilLord
15 - Aurora

Great opportunity to use the Date Time Tool :)

 

Spoiler
Weekly Challenge 2.png
ydmuley
12 - Quasar
12 - Quasar

Here we go for the second one. I found this one very easy. Except had to research on date format, a new learning for me. Also, I have used the Data Cleansing tool which is just awesome and easy one. Comments? Suggestions?

 

2 Down....

Regards,
Yugandhar Muley (Yug)

Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
mceleavey
17 - Castor
17 - Castor

So far so good.

The data cleansing tool saves a lot of time.



Bulien

SeanAdams
17 - Castor
17 - Castor

nicely done Yug - I've not used the "StripQuotes" formula before, so that's fun to see.

 

2 down, 67 to go :-)

ydmuley
12 - Quasar
12 - Quasar

Agreed @mceleavey - Kudos to the team to maintain the simplicity and easy of handling of this tool with some amazing powers!

Regards,
Yugandhar Muley (Yug)

Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
ydmuley
12 - Quasar
12 - Quasar

Thanks Sean - Will be targeting 3rd one now

Regards,
Yugandhar Muley (Yug)

Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
sagarb
8 - Asteroid

Late to the party!!

raj_k
6 - Meteoroid

Solution for Challenge # 2