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

    reply on answer

    D.R.NEVILLE DHAMSIRI 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);