Challenge #2: Preparing Delimited Data

[ankit2284]

Great exercise...... achieved the result through2 methods.

Posting my solution.

Cheers

AJ

[AndreasVoinescu]

Cool, this was my first challenge with the Alteryx Designer. Solution is attached

Spoiler

Text into columns > Removed punctuation > Convert to datetime > Select only relevant columns

[Zmarx1]

Solution posted below

[camille2020]

There are at least couple ways to do this. Either use RegEx and DateTime tools or Formula.

[lkmounir]

Done!

Spoiler

[ayazsheikh]

Spoiler

SPOILER ALERT

[jacob_kahn]

Thanks for the challenge as always, Alteryx ❤️ 

[Buzz]

Spoiler

My Solution:

[FlorianC]

Simple exercise but quite relevant as to the day-to-day data preparation challenges.

Spoiler

[caconrad03]

Spoiler