Archives of the TeradataForum

Message Posted: Tue, 11 Sep 2012 @ 17:37:09 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hello gurus,

My data looks as follows:

     Key 1 , Value1, Time1
     Key1 , Value1, time2
     Key1, Value2, Time 3
     Key1, Value2, time4
     Key1, Value1, time 5
     Key1, Value1, Time6
     Key1, Value2, Time7

So the above data should yield me as follows

     Key1, Value1, Time1, Time2
     Key1, Value1, Time2, Time2
     Key1, Value2,Time3, Time4
     Key1, Value2, Time4, Time4
     Key1, Value1, Time6, Time7
     Key1, Value1,Time7, Time7

We have to identify the groups in sequnce.

	<Prev	Next>		<<First	<Prev	Next>	Last>>