3 Replies Latest reply: Sep 21, 2014 9:24 AM by Robert Hutchings RSS

    Order By doesn't work

    Robert Hutchings


      Hope someone can help me on this

       

      I have set up incremental load

      But this loads the records in a different order

       

      I tried to rectify this (as I need to do a lastvalue)

       

      So I tried to sort this by various order

       

      None work. I have loaded the script below (Call_Num and FSR_Num are both numeric)

       

      Thanks

       

      left keep (SCCall)
      LOAD

      FSR_Call_Num as Call_Num,

      FSR_Num,

      etc
      AutoNumber   (TEXT (Upper (FSR_Ser_Num)) & '/' & TEXT (UPPER (FSR_Prod_Num))) as SerialandProdNo,       if (ApplyMap ('RepCodeAdj',FSR_Call_Num,'Missing')='Missing',FSR_Rep_Code,   ApplyMap ('RepCodeAdj',FSR_Call_Num,'Missing')) as RepCode,     


         AutoNumberHash128  ( FSR_Call_Num , FSR_Ser_Num , FSR_Prod_Num) as CallSerial//new  ifNUM( ApplyMap ('WARRENDMAPP',AutoNumber ( TEXT (Upper (FSR_Ser_Num)) & '/' & TEXT (UPPER (FSR_Prod_Num)))  ,'NoCode')) >

        NUM( ApplyMap ('Callindate', FSR_Call_Num  ,'NoCode')) ,'YES','NO') AS CallInWarr

        resident SCFSRTess
      where not Match (FSR_Employ_Num, '039') and not match  (FSR_Rep_Code,'09',9)
      order by FSR_Call_Num ,FSR_Num          //FSR_Last_Update

      ;