7 Replies Latest reply: Jul 16, 2015 6:26 AM by Gareth Cox-Thorpe RSS

    Creating new field

    Gareth Cox-Thorpe

      Hi all,

       

      I'm having trouble creating a new field in the script my see below,

       

      Load

       

           UNIT.GRADEFIX,

           if( UNIT.GRADEFIX = '', 2,UNIT.GRADEFIX) as UNIT.GRADEFIX_SCORE,

           num(UNIT.M_MILEAGE / 1000) + UNIT.AGEMONTHS + (UNIT.GRADEFIX_SCORE*10) +  (UNIT.CAPCLEAN_ORIG /1000) as Unit.GCT_Score

       

      FROM

      [$(QVD_Path)\BUYER_unit.qvd]

      (qvd);

       

      Does anyone have any idea why I'm getting the error cannot find field?

       

      Thanks