Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAIt was pretty cool approach. I learnt from this.
Here's my solution!
I took a different approach than the posted solution. I split the dataset using sampling tool, 1st 12 and last 12 records, added a record id that matched the month number (1=Jan, 2=Feb, etc.). Used the lookup table to populate the MMM value and then a formula tool to add the year. Then unioned the two data streams back together.