Well i may be wrong about transaction, but let me clarify what i need by giving examples. Lets say that i have data as follows: Event ID Time Source Destination 1 08:00:00 S1 D1 2 08:00:45 S1 D1 3 08:01:30 S1 D1 4 08:02:31 S1 D1 By using transaction i want to group Event ID 1, 2 and 3. Because, the time difference between consecutive events are less than 1min. Here is my desired output: Transaction ID Source Destination Duration 1 S1 D1 90 2 S1 D1 0 Shouldn't transaction command do that? Am i missing something?
... View more