Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #2: Preparing Delimited Data

Highlighted
8 - Asteroid

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

 

Best wishes,

Denise

Alteryx Certified Partner

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

 

Highlighted
Alteryx Certified Partner

Great opportunity to use the Date Time Tool :)

 

Spoiler
Weekly Challenge 2.png
Highlighted
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....

Highlighted
Alteryx Certified Partner

So far so good.

The data cleansing tool saves a lot of time.

Highlighted
16 - Nebula
16 - Nebula

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

 

2 down, 67 to go :-)

Highlighted
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!

Highlighted
12 - Quasar
12 - Quasar

Thanks Sean - Will be targeting 3rd one now

Highlighted
8 - Asteroid

Late to the party!!

Highlighted
6 - Meteoroid

Solution for Challenge # 2