Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Grouping by continuous dates

Hi !
I have a table like this:

StepStartEnd
Step 116/06/2013  09:01:4316/06/2013  09:11:17
Step 216/06/2013  09:11:1716/06/2013  09:16:29
Step 316/06/2013  09:16:29

16/06/2013  10:47:30

Step 416/06/2013  11:05:2016/06/2013 11:05:45
Step 516/06/2013 11:05:4516/06/2013 11:14:09

In the LOAD process I would like to finish with this:

TimeStartEnd
01:45:4716/06/2013 09:01:4316/06/2013 10:47:30

Steps 4 and 5 are not selected because they sum less then 15 minutes.
Is it possible to achieve this ?

Thanks in advance !

Regards,
Itamar

0 Replies