.\Test Set for Review with Alteryx (DDI).xlsx|`Sheet2$`
False
Test Set for Review with Alteryx (DDI).xlsx
Table=`Sheet2$`
FromYear=MIN(ToNumber(DateTimeFormat([From Date],"%Y")),
...
ThruYear=MIN(ToNumber(DateTimeFormat([Thru Date],"%Y")),
...
C:\myTemp\Alteryx\Engine_15820_8e5859007ccf479b9ae3d62d5b6a3a7a_\Engine_11652_f275898bb5d343ccaf11a454c206a642_.yxdb
Region - Ascending
PO - Ascending
Part# - Ascending
Contact RecordID - Ascending
...
From Date
NewField
Int32
254
NULL
IIF([FromDateMinusOne] == [Row-1:Thru Date],
[Row-1:From Date],[From Date])
IIF([FromDateMinusOne] == [Row-1:Thru Date],
[Row-1:From ...
FromDateMinusOne=DateTimeAdd([From Date],-1,"days")
Horizontal
CreatingContinuedCoverageRows