7 Replies Latest reply: Feb 23, 2018 11:32 AM by Rob Wunderlich RSS

    Rowno function in script that resets after a particular count

    Vishnu Chakravaram

      All,


      Here's my requirement


      Should be done in script.

       

      From:

       

      Product, Value, RowNo

      A,10,1

      A,,20,2

      B,30,3

      B,40,4

       

      to

       

      Product, Value, RowNo

      A,10,1

      A,,20,2

      B,30,1

      B,40,2

       

      Basically for each value of Product, the rowno() should reset and start from 1.