4 Replies Latest reply: Nov 10, 2016 12:17 PM by John Witherspoon RSS

    give sequence number in script

    Mark Graham

      Hi all,

       

      I'm trying to give sequence to the value of ID. Grouped by ID, for every Value i would like to give a sequence number - 1,2,3

      No specific order. Just a sequence number for every instance grouped by ID.

       

      Data:

       

      IDValue
      1P0132-9540
      1P8594-123
      1P213098-323
      2P-9540
      2P-123
      2P-323

       

      O/P:

        

      IDValueSequence
      1P0132-95401
      1P8594-1232
      1P213098-3233
      2P32-95401
      2P94-1232
      2P98-3233

       

       

      Any help is highly appreciated.