reply on answer

[nevilledhamsiri]

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);

[felipedl · Accepted solution]

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);