We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #237: Wareki

AYXAcademy
Alteryx
Alteryx

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

 

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.

johnemery
10 - Fireball

This was a really enjoyable challenge!

 

Spoiler
Capture v2.PNG

Watch my solution video here:

Spoiler
Aaron_Harter
11 - Bolide
Spoiler
237.1.PNG
dsmdavid
11 - Bolide

Went with a calendar table

Spoiler
dsmdavid_0-1602513300255.png
dsmdavid_1-1602513321821.png

 

 

JennyMartin
9 - Comet
Spoiler
AWC237M.PNG

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

Blake
12 - Quasar

That was a fun and interesting macro challenge. 

 

Spoiler
237.png

 

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

Spoiler

 

RolandSchubert
15 - Aurora
15 - Aurora
Spoiler
237.png

Nice challenge. 

patrick_digan
16 - Nebula
16 - Nebula
Spoiler
patrick_digan_0-1602521217357.png

patrick_digan_1-1602521257601.png

 

 

OllieClarke
13 - Pulsar
13 - Pulsar

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

Spoiler
WorkflowWorkflowMacroMacroMacro InterfaceMacro Interface
Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 237 is done!

 

Interface:

Spoiler
challenge 237 JMS solution.PNG

Macro:

Spoiler
challenge 237 JMS solution macro.PNG