Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
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

Sus7
5 - Atom

This is my first challenge attempt. Solved this a bit differently. I have used 'Data Cleansing' tool and 'DateTime' tool.  Attached the Solution here:

annaprosvetova
7 - Meteor

Great little challenge to refresh Alteryx skills.

Slacker
8 - Asteroid

My Solution

byagelski
8 - Asteroid

my solution

PaulGriffiths
5 - Atom

I enjoyed that

Spoiler
PaulGriffiths_0-1611327929836.png

 

sevans210189
6 - Meteoroid

Solved

 

Spoiler
Weekly Challenge #2.png
Emily_P
7 - Meteor

Done!

mpoon
5 - Atom

My solution is slightly different from the given solution.  I used the trim function to remove excess quotations and datetime tool to fix up my date column.

jeremyhaber814
7 - Meteor

Challenge 2

EmmyCC
7 - Meteor

This is a very clever challenge, I spent a long time figuring how to trim " and ' , then I decided to treat them both as delimeters then parse each record into 5 fields (date, mon, year are three fields), then I use formula tool to combine them all together back to a new field.... it worked but knowing how to deal with quotes and single quote in expression is very important. Thanks I have learned that from this challenge 🙂