01/04/2020 06:00:06
2
01/04/2020 06:15:06
4
01/04/2020 06:30:06
5
01/04/2020 06:45:06
15
01/04/2020 07:00:06
16
01/04/2020 07:15:06
18
01/04/2020 07:30:06
19
01/04/2020 07:45:06
23
01/04/2020 08:00:06
25
01/04/2020 08:15:06
28
01/04/2020 08:30:06
31
01/04/2020 08:45:06
32
01/04/2020 09:00:06
37
01/04/2020 09:15:06
41
DateTime
dd/MM/yyyy hh:mm:ss
DateTime_Out
Convert DateTime From:
dd/MM/yyyy hh:mm:ss
AccumulativeValue
Date n Hour
V_WString
64
Empty
IF DateTimeHour([Row-1:DateTime]) = DateTimeHour([DateTime])
THEN [Row-1:Date n Hour]
ELSE [DateTime]
ENDIF
IF DateTimeHour([Row-1:DateTime]) = DateTimeHour([DateTime])
...
Date n Hour
RealValue
Int32
4
NULL
IF isNull([Row-1:AccumulativeValue])
THEN Null()
ELSE [AccumulativeValue]-[Row-1:AccumulativeValue]
ENDIF
IF isNull([Row-1:AccumulativeValue])
THEN Null()
ELSE [Accumu...
C:\_Data\Alteryx\tmp\Engine_23664_469f7766dc274ac8976d6045795516e5_\Engine_9684_96c8a11f13e845a7ab86c0a34c915cd4_.yxdb
Single
Profile
Horizontal
2020-04-25-Remove time and extract from accumulative values