6 Replies Latest reply: Jun 29, 2015 11:10 AM by Rob Wunderlich RSS

    Count for Each Record

      Hi All ,

       

      TRN ID

      Date

      Time

      123A

      6/1/2015

      10:00 AM

      123A

      6/1/2015

      10:30 AM

      145A

      7/1/2015

      11:00 AM

      156A

      7/1/2015

      11:00 AM

      156A

      7/2/2015

      10:00 AM

       

      For the Above table ,

      i need to add a counter for each TRN ID sorted based on Date and Time.

       

      And the Counter will be used as a KEY for further calculations.

       

      Final Expected Output

       

      TRN ID

      Date

      Time

      Counter

      123A

      6/1/2015

      10:00 AM

      1

      123A

      6/1/2015

      10:30 AM

      2

      145A

      7/1/2015

      11:00 AM

      1

      156A

      7/1/2015

      11:00 AM

      1

      156A

      7/2/2015

      10:00 AM

      2

       

       

      Regards,

      Senthil