5/17/2018 13:09:48+00:00
ID1
ID1_4
5/20/2018 15:09:48+00:00
ID2
ID2_1
5/17/2018 11:09:48+00:00
ID3
ID3_2
5/14/2018 19:09:48+00:00
ID1
ID1_2
5/22/2018 18:09:48+00:00
ID2
ID2_2
5/17/2018 14:09:48+00:00
ID1
ID1_3
5/14/2018 14:09:48+00:00
ID3
ID3_2
5/13/2018 14:09:48+00:00
ID3
ID3_2
5/11/2018 14:09:48+00:00
ID3
ID3_1
5/14/2018 19:09:48+00:00
ID1
ID1_4
1/14/2018 19:09:48+00:00
ID3
ID3_2
2/22/2018 18:09:48+00:00
ID1
ID1_3
2/18/2018 18:09:48+00:00
ID1
ID5_6
6/8/2018 18:09:48+00:00
ID1
ID1_3
Table 1
Used_Date = Replace([Used_Date], '+00:00', '')
Used_Date = ToDate((DateTimeParse...
Used_Date - Ascending
Parent_part - Ascending
child_part - Ascending
C:\ProgramData\Alteryx\Engine\Engine_17164_569cac4830f44087a7f37ba6275dbfc2_\Engine_5856_08ca0e373252485fa51ffbecd23ca528_.yxdb
Single
Profile
=0 and [Day_diff]<=7 then 1 else 0 endif
]]>
Used_Date
Day_diff
Int32
4
Empty
DateTimeDiff([Used_Date],[Row-1:Used_Date],"days")
DateTimeDiff([Used_Date],[Row-1:Used_Date],"days")
wrong_flag = if [prt_7d_used_flag]=0 and [prt_7d_used_count]>0 then 1 else 0 end...
RecordID
1
Int32
6
0
Horizontal
looping through 2 input files2nd version