Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Grouping the data and pulling the max value when different windows exist
 
From:   sivaram nelluri

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016