community
cancel
Showing results for 
Search instead for 
Did you mean: 
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.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #2: Preparing Delimited Data

Definitely could do less steps in the future when I get better

Meteor

My solution:

Spoiler
Spoiler!



Challenge 2 Solution.png

 

Alteryx Certified Partner
 
Meteoroid

Posting my solution.

Meteoroid

Hi,

 

Thank you for the solution.

I am new to alteryx and learning from different resources within the community for which I would like to thank everyone here.

In solution to challenge #2 I did not get the %b date format in "DateTimeParse(trim([3],"'"),"%d-%b-%y") 

 

As per the document it is "mmm" format for %b and "MMM" format for %B but when I am changing it to some other value as per the learning document I am not getting the desired result. 

Could anyone please help?

Atom

My solution

Spoiler
Challenge2.JPG
Asteroid
Spoiler
clipboard_image_0.png
Asteroid
 

Here is my solution.  Plugging away at getting my badges.  Thanks

Atom

My answer. It works as long as the input file has a standard format.