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

Sus7
6 - Meteoroid

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
6 - Meteoroid

I enjoyed that

Spoiler
PaulGriffiths_0-1611327929836.png

 

SimonEvans
8 - Asteroid

Solved

 

Spoiler
Weekly Challenge #2.png
Emily_P
8 - Asteroid

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 🙂