Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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