Weekly Challenge

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

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

Submit Feedback
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.

Challenge #237: Wareki

Highlighted
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.

Highlighted
Alteryx Partner

This was a really enjoyable challenge!

 

Spoiler
Capture v2.PNG

Watch my solution video here:

Spoiler
Highlighted
Alteryx Certified Partner
Spoiler
237.1.PNG
Highlighted
Alteryx Partner

Went with a calendar table

Spoiler
dsmdavid_0-1602513300255.png
dsmdavid_1-1602513321821.png

 

 

Highlighted
Alteryx Partner
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

Highlighted
Alteryx Certified Partner

That was a fun and interesting macro challenge. 

 

Spoiler
237.png

 

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

Spoiler

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
Spoiler
237.png

Nice challenge. 

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

patrick_digan_1-1602521257601.png

 

 

Highlighted
Alteryx Certified Partner

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

Spoiler
WorkflowWorkflowMacroMacroMacro InterfaceMacro Interface
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Challenge 237 is done!

 

Interface:

Spoiler
challenge 237 JMS solution.PNG

Macro:

Spoiler
challenge 237 JMS solution macro.PNG