Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Get the previous event_start_dt_tm grouped by account number, event, and day
- [_PREVIOUS_EVENT_START_DT_TM]
- ===
- IF
- ATTR([FIN]) = LOOKUP(ATTR([FIN]), -1)
- AND ATTR([EVENT_CD]) = LOOKUP(ATTR([EVENT_CD]), -1)
- AND ATTR(DATETRUNC('day', [EVENT_START_DT_TM])) = LOOKUP(ATTR(DATETRUNC('day', [EVENT_START_DT_TM])), -1)
- THEN LOOKUP(ATTR([EVENT_START_DT_TM]), -1)
- ELSE NULL
- END
- Calculate event_start_dt_tm difference in minutes
- [_LKP_EVENT_START_MINS]
- ===
- DATEDIFF('minute',[_PREVIOUS_EVENT_START_DT_TM],ATTR([EVENT_START_DT_TM]))
Advertisement
Add Comment
Please, Sign In to add comment