1 Reply Latest reply: Aug 14, 2017 2:02 PM by Felip Drechsler RSS

    reply on answer

    NEVILLE DHAMSIRI

      Applied the said formula, but an error comes in loading the data, Look forward to resolve this!

       

      LOAD CLASS_CODE,

           Pick(Match(CLASS_CODE,'MC','M3','M4')+1,'NONMOTOR','MOTOR','MOTOR','MOTOR',

           PREMIUM

      FROM

      D:\CLASS.xlsx

      (ooxml, embedded labels, table is Sheet1);

        • Re: reply on answer
          Felip Drechsler

          Hi Neville,

           

          You're missing a parenthesis on the Pick statement

          Like this

           

          LOAD CLASS_CODE,

               Pick(Match(CLASS_CODE,'MC','M3','M4')+1,'NONMOTOR','MOTOR','MOTOR','MOTOR') as T,

               PREMIUM

          FROM

          D:\CLASS.xlsx

          (ooxml, embedded labels, table is Plan2);