Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to deal with wrong format of data ?
I have a table like this
Time 1 | Time 2 | Interval |
---|---|---|
2.1.2017 20:00 | 2.1.2017 21:00 | Interval between Time2-and UpperTime1 |
1.1.2017 20:00 | 1.1.2017 21:00 | Interval between Time2-and UpperTime1 |
How can i calculate Interval between Time 2 ( Lower line ) and Time 1 ( Upper line )
I tried this, but red line didnt give any result ... the formated times are displayed good.
data:
Load
*,
[Formated Time 2] - peek([Formated Time 1]) as Difference;
Load
RecNo() as Index,
date#([Time 1],'M.D.YYYY hh:mm') as [Formated Time 1],
date#([Time 2],'M.D.YYYY hh:mm') as [Formated Time 2]
data:
LOAD
*,
[Formated Time 2] - Previous([Formated Time 1]) as Difference;
LOAD
RecNo() as Index,
date#([Time 1],'M.D.YYYY hh:mm') as [Formated Time 1],
date#([Time 2],'M.D.YYYY hh:mm') as [Formated Time 2]
FROM SourceFile;