17 Replies Latest reply: Feb 16, 2011 7:26 PM by Karl Pover RSS

    Create New Field in Script

    Joe Kirwan

      I want to creat a new field in my table that ranks the instance of TR.REF for each SORDREF.

      So, instance of TR.REF 282117 for SORDREF 142871 is 1, instance of 283479 is 2, etc as per below

       

      DATESORDREFTR.REFITEMCODENEW FIELD
      04/01/201014287128211733E01 -(222901)1
      04/01/201014287128211733E10 -(222902)1
      04/01/2010142871282117MTCRCA091
      04/01/2010142871282117ZR5RT0111
      04/01/20101428712821171722.471
      04/01/2010142871283479333E - (222964)2
      04/01/201014287128398117073
      04/01/2010142871285213ZR5MF0114
      04/01/2010142872282070100606531
      04/01/2010142872282070100664011
      04/01/2010142873282071100606531
      04/01/2010142874282049013 - 41
      04/01/20101428742820494861.0631
      04/01/20101428742899432202.03152
      04/01/20101428742899442202.03153
      04/01/2010142875282036690 DZII1
      04/01/2010142876282057BB27181
      04/01/2010142876282057E2718O1
      04/01/2010142877282079OBS/4863.0631


      PS - am a Personal Edition user