Challenge #237: Wareki

A solution to last week's challenge can be found here.

The Wareki is a Japanese date format which includes an extra character to signify the era. The eras indicate the emperor at the time and they impact the year only. For example, H04/01/31 represents the 4th year of Heisei era, but the 01/31 is in fact January 31st of that year.

Modern Japan, which is considered the period beginning in 1868, is currently in its 5th era. This week's challenge is to create a macro that converts Wareki dates into Alteryx Datetime or vice versa. The macro should include a configuration option for Wareki to Date or Date to Wareki.

challenge_237_start_file.yxmd

challenge_237_solution.yxzp

Parse

Macros

Join

Preparation

Advanced

Intermediate

Interface

Accepted answers

All comments

johnemery

This was a really enjoyable challenge!

Spoiler

Watch my solution video here:

Spoiler

Challenge 237 Solution jemery.yxzp

Aaron_Harter

Spoiler

WC237_AB Data_Aaron.yxzp

dsmdavid

Went with a calendar table

Spoiler

david_237.yxzp

JennyMartin

Spoiler

Great challenge for practising standard macros. Video solution here: https://www.youtube.com/watch?v=q27zJiC_n2A&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=41

AWC237.yxzp

Blake

That was a fun and interesting macro challenge.

Spoiler

Edit 14:40 on 2020-10-12 to add video walkthrough

Spoiler

WC237BH.yxzp

RolandSchubert

Spoiler

Nice challenge.

Warecki.yxzp

patrick_digan

Spoiler

challenge_237_start_file.yxzp

OllieClarke

Here's my solution to this week's challenge:

Spoiler

Workflow

Macro

Macro Interface

challenge_237_OC_solution.yxzp

Wareki Date Converter.zip

Jonathan-Sherman

Challenge 237 is done!

Interface:

Spoiler

Macro:

Spoiler

challenge_237_start_file.yxzp

AngelosPachis

My solution for challenge #237

Workflow

Screenshot 2020-10-12 185614.jpg

Macro

Spoiler

challenge_237_solved_AP.yxzp

ehughes

Definitely learnt some things with this one

Spoiler

AWC237 Wareki Date Converter.yxmc

TonyA

Really enjoyed this one, having lived in Japan for several years. I made a couple of tweaks, including a validity test on the Wareki date to ensure it was valid. For example, S010131 would not be valid (Showa started in December of 1925), neither would H251231, since Heisei only lasted 20 years.

Spoiler

I also made some changes to the Era Definitions, changing the dates to date format and adding a column for start year. It didn't make sense to keep the original file and make the same changes to it every time the macros were called. I included the workflow to make the that created the modified data set in the package.

Main Workflow

Wareki to Date Macro

Date to Wareki Macro

challenge_237_TonyA.yxzp

LHolmes

Fun challenge. Great to work on some macros!

Spoiler

challenge_237_solution_lmh.yxzp

JethroChen

Spoiler

challenge_237_jc.yxzp

Nanoq

I have a feeling that i could optimize my macro more, but this does the trick

Challenge_237.yxmc

kelvin_law1

Fun challenge!! Here is my solution.

Spoiler

Here is the macro workflow:

challenge_237_solution.yxzp

Qiu

Not sure its a Macro already.
Just list up all the dates.

Spoiler

challenge_237_start_file-Qiu.yxzp

DaisukeTsuchiya

This macro is one which I need!

This conversion is troublesome for Japanese, too.

Spoiler

challenge_237_start_file_DT.yxzp

Sashikumar

Cool Stuff 😎

Spoiler

challenge_237_start_file_sk.yxmd

challenge_237_start_file_sk.yxmc

Spalders

Spoiler

Challenge_237.yxmc

AkimasaKajitani

My solution.

I put the era definitions into the macro.

Spoiler

I recommend that you also test with the following data.

testdata.csv

challenge_237_start_file_AK.yxzp

phottovy

I'm not sure my solution required a macro but I built one anyway.

Spoiler

challenge_237_ph_solution.yxzp

huynv96

Challenge 237 was solved, thank

Spoiler

Challenge_237_huynv96.yxzp

Kenda

Spoiler

Idk if this is cheating or not, but mine doesn't explicitly force the user to choose which type of conversion they want to do, it just automatically handles whatever is fed in. 👍