Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #237: Wareki

AngelosPachis
Nebulosa

My solution for challenge #237

 

Workflow 

Screenshot 2020-10-12 185614.jpg

 

Macro

 

Saqueador
Screenshot 2020-10-12 185415.jpg
ehughes
Cometa

Definitely learnt some things with this one

Saqueador
Img 237.png

Img 237 - macro.png

TonyA
Alteryx Alumni (Retired)

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.

Saqueador
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

2020-10-12_13-39-47.png
Wareki to Date Macro
2020-10-12_13-43-12.png
Date to Wareki Macro
2020-10-12_13-46-00.png

 

LHolmes
Cometa

Fun challenge. Great to work on some macros!

 

Saqueador
237 - Solution.PNG
237 - Macro.PNG
JethroChen
Bola de fogo
Saqueador
challenge_237_jc.PNG
Nanoq
Asteroide

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

kelvin_law1
Cometa

Fun challenge!!  Here is my solution.

Saqueador
kelvinlaw_0-1602576031207.png
Here is the macro workflow:
kelvinlaw_2-1602576101449.png
Qiu
21 - Polaris
21 - Polaris

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

Saqueador
en-237.PNGen-237-1.PNG
DaisukeTsuchiya
14 - Magnetar
14 - Magnetar

This macro is one which I need!

This conversion is troublesome for Japanese, too.

Saqueador
キャプチャ1.JPGキャプチャ2.JPG
Sashikumar
Asteroide

Cool Stuff 😎

Saqueador
ch237.PNG