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

scotthall
5 - Atom

My solution to #2:

 

Spoiler
Wk 2 Soulution SC.jpg

 

alishapaul
5 - Atom

My solution was a bit longer but this helped to learn some new functions for the formula tool! Thanks!

 

Spoiler
challenge_2_AlishaPaul.JPG
husainamjhera
5 - Atom

My Solution!!

Posting the solution after 3 years.

I think I took a lot of time  🙂

rrenu59
6 - Meteoroid

Here is my workflow for this challenge

 

cmoore1
5 - Atom

I used Text To Columns to remove all the delimiters, including the ",', then the DateTime Parser to correct using the custom date time. 

twilko2
6 - Meteoroid
 
kmalone007
8 - Asteroid

Solution

RRS
7 - Meteor

My Solution

zannanie
5 - Atom
 
DBourke19841
8 - Asteroid

Been using Alteryx for almost a year now - the time savings it has generated has allowed me to now participate in weekly challenges and try improve and automate further - great tool. I hope I'm right!!