4 Replies Latest reply: Apr 30, 2014 3:13 PM by NAGA CHIRANJEEVI THOTA RSS

    Want to create one more column to group the sequence no as buckets

    NAGA CHIRANJEEVI THOTA

      Hi all,

       

      I have data as below

       

       

      Date,   SequenceNO

      04/30/2014,   1

      04/29/2014 ,   2

      04/28/2014,    3

      04/27/2014,    4

      ............... so on

       

       

      Now I want to create one more column Bucket to group my Sequence No's.

       

      SequenceNoBucket
      1-301
      30-602
      60-903

       

      Date,   SequenceNO ,Bucket

      04/30/2014,   1  ,1

      04/29/2014 ,   2 ,1

      04/28/2014,    3 ,1

      04/27/2014,    4 , 1

      ............... so on

      03/01/2014,31,2

      03/02/2014,1,2

       

      thanks in Advance,

      Chiru