11 Replies Latest reply: Aug 22, 2018 10:27 AM by vamsee duggirala RSS

    Assign Row Numbers

    Jamel Messaoud

      Hi guys,

       

      I have some data like below

       

           

      Row No.TypeLoadIDConsIDJobID
      0Master6008011090480625720
      1Leg6008011090480625910
      2Leg6008011090480625911
      0Master69409259682135644897
      1Leg69409259682135644901
      2Leg69409259682135644902
      0Master71072459705448647807
      1Leg71072459705448647971
      2Leg71072459705448647972
      3Leg71072459705448647973

       

      Any idea how I would go about assigning the row numbers like the above example?  I have played about with the Autonumber function but I cannot figure this one out!

       

      The type Master is always 0 and then the others I would like to autonumber.

       

      Help!

       

      Thanks
      J