Challenge #2: Preparing Delimited Data

[leonhekkert]

My solution!

Spoiler

[DeanLewis]

Challenge 2 Completed, I am new to Alteryx and had to check the solution to make sure I was on the right path! I'm not sure I understand the date formatting in regards to the specifiers. I used "%Y-%m-%d" which obviously failed because %m requires a month number as the input not text, however, %b is supposed to return an abbreviated month i.e. "Jun" but it is outputting a number designation instead. If anyone can ELI5 this for me that would be great!

Thanks

[Jon-Knepper]

Spoiler

Here is my Solution!

[James007]

Here goes my solution workflow for the challenge-02

Spoiler

Solution Workflow

[tim-bakker]

Spoiler

[rohit782192]

Awesome Learning .

1. I have learn formula tool to strip the quotes from a Text String.

2. Date time converter tool to convert from String to Date time format.

3. text to column tool to split the data into different column by separating delimiter

[Aguisande]

Here's #2.

Spoiler

[ScottJohnston2021]

Nice

[nagakaladhar]

I enjoy solving these challenges

Thanks

[Diederik_vanderharst]

Voila

Spoiler