Free Trial

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

KalpanaM
7 - Meteor

Done. Learnt a new way of date formatting when i see the Date is in '16-Jun-01'.

summer1224
5 - Atom

I am a very beginner, just starting to learn how to play with data in Alteryx 😅.

Here's my solution - I struggled a bit for the date parsing, but got my first practice done!  

khoekema
7 - Meteor

:RegEx:

MStrauser
5 - Atom

I like your solution better.  It's more elegant.

 

PS - my company won't let me attach a workflow.  I'm hoping this screenshot showing I actually did it works.

CMWalsh
8 - Asteroid
Spoiler
CMWalsh_0-1660295246660.png

 

lkim524
8 - Asteroid

my solution

samuelbirmaherjr
6 - Meteoroid

Solution

mnikolaeva
7 - Meteor

my solution:

 

Spoiler
Capture d’écran (41).png

Antonio1969
5 - Atom

Hi!.

This is my first challenge, so I'm sorry if the question is too basic. I don't understand where the error is when using the tool to pass from text to date.
Thank you!

Attached a partial solution. Thank you

 

KalpanaM
7 - Meteor

When date is in "2021-Jun-19" then we should use the custom and Use the %y-%b-%d. I have attached updated file.