Analyzing 2 rows of data

[Anonymous]

Hello guys,

I have a problem, I would like to analyze my data 2 by 2 rows.

Id	Time	EventId	Type
1	15-06-2009T13:45:30	1	End_Time
1	15-06-2009T13:45:34	4	Something

This is my data. For example, we have id of an operation, End_Time of an operation, EventId etc. and it is an consequent Event for the same operation. I would like to get the Count of id, which have started with EventId = 1 and Type = 'End_Time' and consequent action with EventId = 4, but the maximum difference between time should be 5 seconds.

I attach excel file with more data but imagine there are many types of EventId and Type.

Regards,

Todor

[stigchel]

I would add a field on the same row for EventId=1 with the subsequent time for EventId=4 and flag the records that are 5 seconds or less. Something like attached. Depending on your other needs/datamodel you can add other fields and/or rows