Challenge #21: Date Reformatting

The link to last week’s challenge (challenge #20) is HERE. For this week’s challenge we have an easier one that requires the reformatting date fields. The input data has very poorly formatted month and year information that will require you to build some logic to make it usable.

Use Case: A company needs to reformat a month/year flag in a data asset they received for a consulting project.

You will need to take the Date field provided and separate it into fields for the Month and Year. For example, F07 should become 2 columns where month is Feb and year is 07.

Have fun!

challenge_21_start_file.yxmd

challenge_21_solution.yxmd

Preparation

Advanced

Data Analysis

Data Preparation

Basic

Accepted answers

All comments

ed_hayter

Spoiler

challenge_21_flow.yxmd

lyon_abido

Spoiler

A bit of a brute force strategy I think, but I got it. Fun challenge!

jerviss53

Solution Attached

challenge_21_solution.yxmd

CeliaC_Silje

Spoiler

challenge_21_start_file.yxmd

dougbaron

Spoiler

challenge_21_final_file.yxzp

carol2021

Solution

challenge_21_start_file.yxmd

Archie_bos

here is my solution

challenge_21_complete_file.yxmd

katestrohm

1. Formula 1: Left([Date], 1)

Formula 2: IF Length([Date]) >2 THEN Right([Date], 2) ELSE "" ENDIF

2. Multi-Row Formula for the Year column: IF IsEmpty([Year]) THEN [Row-1:Year] ELSE [Year] ENDIF

3. Multi-Row Formula to create a month number/count column: [Row-1:Month number]+1

4. Switch function to replace numbers with month abbr: Switch([Month number],Null(),1,'Jan',2,'Feb',3,'Mar',4,'Apr',5,'May',6,'Jun',7,'Jul',8,'Aug',9,'Sep',10,'Oct',11,'Nov',12,'Dec')

5. Select tool to hide a month number/ count column

Spurs

Spoiler

challenge_21_FINISHED.yxmd

nbendoff

solution

Weekly Challenge 21.xlsx

bhrmitra

Solution Attached !!

21. Challenge_21_Solved_bhrmitra.yxmd

tosdrive

c_21workflow.yxdb

BS_THE_ANALYST

Nice! Tried to take a route using a lookup table via generate rows:

Spoiler

challenge_21_BS.yxmd

PrachiD

Submission for ADV challenge_21_ Adv data Prep using Text to column, find replace and multirow

Submission for ADV challenge_21_ Adv data Prep.yxmd

Sebastian_Chaieb2

Spoiler

challenge_21_Solution_SC.yxmd

elaineyuan

Last challenge today!

Spoiler

challenge_21_elaine_yuan.yxmd

Hammad_Rashid

Screen Shot 2017-08-27 at 18.22.13.png

Challenge_21_HR.yxmd

Amilley

**Spoiler**

I used some batch concepts leveraging the multi-row... curious on how others tackled as well.

challenge_21_Solution_03.27.2023.yxmd

mg46

Here's my solution.

Spoiler

challenge_21_Michelle_G.yxzp

Powerhouse_21

Spoiler

PH21_Challenge_21.yxmd

scooby_snacks

My solution.

challenge_21_solution_scooby_snacks.yxmd

JS1989

Solution

Solution_challenge_21_start_file.yxmd

sanjay_shinde

Here is my solution

challenge_21_solution sanjay.yxmd

elena_mazareanu

Solved

challenge_21_start_file_solved.yxmd

kaitlinDS37

Spoiler

chandler-gjino

Attaching my solution

21_Advanced_Basic_Preparation.DataAnalysis.DataPreparation.yxmd

lucaskro

Spoiler

challenge_21_start_file.yxmd

tristank

Had to break from challenge 20 which has been beating me down lol. Did it in three tools like most other solutions.

Spoiler

challenge 21 completed.yxmd

krishnakumare

A solution posted using Multirow formula and formula tools

MitchellBliesner

I'm slowly working my way through the Alteryx Challenges. I've only been learning Alteryx for a few weeks. I've really been enjoying it. Anyway, here is my solution to the challenge.

Spoiler

challenge_21_completed.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335