15 Replies Latest reply: Sep 17, 2014 4:00 AM by Manish Kachhia RSS

    Assign row no

      Hi there,


      If I had a table of data like the below, is it possible to have 3 column generated where by it increments by 1 each time the record in A is found?


      So A can occur one or more times but B is unique.


      Hope this makes sens.






      A               B               C

      test1         apple          1

      test1         orange        2

      test2         apple          1

      test3         apple          1

      test3         pear            2