M
Meiji
10-23-1868
07-30-1912
T
Taisho
07-31-1912
12-25-1926
S
Showa
12-26-1926
01-07-1989
H
Heisei
01-08-1989
04-30-2019
R
Reiwa
05-01-2019
Era Definitions
Era Definitions
2019-01-31
S550730
1997-05-24
S640106
H150224
1999-03-21
1982-12-03
2019-01-09
R011101
1926-02-25
M450522
S550730
1980-07-30
S640106
1989-01-06
H150224
2003-02-24
R011101
2019-11-01
M450522
1912-05-22
Warecki to date
Warecki to date
2019-01-31
H310131
1997-05-24
H090524
1999-03-21
H110321
1982-12-03
S571203
2019-01-09
H310109
1926-02-25
T150225
Date to Warecki
Date to Warecki
Start
Last
Start
Simple
Contains
Field1
True
fixed
2021-08-02 21:17:51
0
-
2021-08-02 21:17:51
2021-08-02 21:17:51
Contains([Field1],"-")
Field1
ParseComplex
Field1
Warn
Field1_Matched
D:\Alteryx Temp Dir\Engine\Engine_30064_92d40346ba364045ba760ebcf5ffc626_\Engine_32016_71a1efb847a3418a86ebd54ec185d258_.yxdb
Single
Profile
Std Yr = [Start Yr]+[Era Year]-1
Std Date = tostring([Std Yr]) + '-' + padleft(...
Std Date - Ascending
Date - Ascending
D:\Alteryx Temp Dir\Engine\Engine_30064_92d40346ba364045ba760ebcf5ffc626_\Engine_32016_01b761baf9ae4c488e3e723ba4d1e109_.yxdb
Single
Profile
Field1
Last
Allow
D:\Alteryx Temp Dir\Engine\Engine_30064_92d40346ba364045ba760ebcf5ffc626_\Engine_32016_0120c58cbe964bd2b0b5442f84644125_.yxdb
Single
Profile
Era = If [Date]>[Meiji] and [Date]<[Taisho] then 1868
Elseif [Date]>[Taisho] and...
D:\Alteryx Temp Dir\Engine\Engine_30064_92d40346ba364045ba760ebcf5ffc626_\Engine_32016_690a2e9a014a423bafebc5710fa15104_.yxdb
Single
Profile
Start
English
MM-dd-yyyy
Start_Date
Convert Start From:
MM-dd-yyyy
Alteryx Educational Asset - Terms and Conditions
Use of this Alteryx asset is for educational purposes only and bound by the conditions set forth on alteryx.com/terms-and-conditions. Alteryx Information may not be reproduced, transmitted or distributed without Alteryx, Inc.'s permission.”
Horizontal
challenge_237_MT_Solution