Challenge #21: Date Reformatting

[hieu_hoang]

This is my solution. 

[dpencheva]

Here is my solution. ; )

[Mélanie]

Niceeeeeee

[sumanthskumar]

Number 5 done and dusted

[mulvihi11]

New to Alteryx and Formulas have been the most challenging of my commonly-used tools. So really great practice here!

Spoiler

[Varshaa]

Spoiler

SPOILER

Ran in 1.3 seconds.

Assigned RecordID to each row since data was in order. Assigned "Year" based on record IDs. Modified record IDs to form 1-12 numbers. Used a static data table assigning month names for 1-12 numbers. Performed a Join on RecordID

[Emil_Kos]

Hi,

Sharing my solution.

In situations like this using the Text tool make our life much easier. If you have option to use complex formula or Join tool + text input tool I would always suggest using the second option.

Spoiler

[DMContente]

Here's my solution

[edavilac]

My solution attached

Spoiler

Not a fancy one, but wanted to avoid writing a big IF

[DavidLane]

Using a bit of the regex skills refreshed in the last challenge and then some simple appending and joining worked well for me.

It does rely on all months being present for all years, but other than that seems fine.

Spoiler