Challenge #237: Wareki
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
AngelosPachis
16 - Nebula
10-12-2020
10:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ehughes
9 - Comet
10-12-2020
12:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Definitely learnt some things with this one
TonyA
Alteryx Alumni (Retired)
10-12-2020
01:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Main Workflow
Wareki to Date Macro
Date to Wareki Macro
LHolmes
9 - Comet
10-12-2020
03:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
JethroChen
10 - Fireball
10-12-2020
07:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Nanoq
8 - Asteroid
10-13-2020
01:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
kelvin_law1
9 - Comet
10-13-2020
01:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Fun challenge!! Here is my solution.
Spoiler
Here is the macro workflow:
Here is the macro workflow:
Qiu
21 - Polaris
10-13-2020
01:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Not sure its a Macro already.
Just list up all the dates.
DaisukeTsuchiya
14 - Magnetar
10-13-2020
02:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sashikumar
8 - Asteroid
10-13-2020
03:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Cool Stuff 😎