Data Engineering Integration
- Data Engineering Integration 10.2.2
- All Products
_event_id Ascending. Arranges the data chronologically by ascending event ID.
trip_id. Groups the rows according to trip ID so calculations are based on events from the same trip.
Not specified. Window functions access rows based on the offset argument and ignore the frame specification.
LAG ( _event_time, 1, NULL )
DATE_DIFF ( _event_time, LAG ( _event_time, 1, NULL ), 'ss' )
IIF ( DATE_DIFF < 60 or ISNULL ( _event_time ), 'Skip', 'Valid' )
Updated July 10, 2020