community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #2: Preparing Delimited Data

Atom

here you go.. used RegEx, text to Columns and Formula tools.

Thanks,

Sri

Atom

did it using parse tools and date time converter did this with a beginner level knowledge but your way was interesting.

Please see attached for my solution.

 

Thanks!

Johannes

Atom

My attempt

Meteor

#2 down, although I imagine this was a bit harder with older versions of alteryx. 

Asteroid

Used Regex to remove the " - sledgehammer to crack a nut? :)

Bolide

2 down, 142 to go...

Moderator
Moderator

 

First attempt is likely over complicated, but hey, I'm on the board! 143 more to go.

 

Spoiler

Mads_Week2.PNG

 

 

Meteoroid

StripQuotes function in Formula or Multi-Field tool? The second one looks more sustainable.

Meteoroid