Alteryx Weekly Challenge

Download a Free Trial of Alteryx! tinyurl.com/y5...
Join us while we build our solution for Alteryx Weekly Challenge #237!
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.
community.alte...
***********************************************************************************************
What is Alteryx?
Revolutionizing business through data science and analytics, Alteryx offers an end-to-end analytics platform that empowers organizations to break data barriers, deliver insights, and experience the thrill of getting to the answer faster. Hundreds of thousands of users all over the world rely on Alteryx daily to deliver real business results.
***********************************************************************************************
AB Data Consulting understands data challenges and equips teams with the knowledge, tools and confidence to overcome those obstacles and lead a digital transformation. Automation enables you to provide detailed process documentation, remove any key person risk, and transition away from ‘unwritten rules’ in data processing.
www.abdatacons...
Alteryx Weekly Challenges is a video series produced by AB Data Consulting for educational purposes and for use by anyone interested in learning Alteryx. To request additional videos, email [e-mail].