topic Re: reply on answer in QlikView

reply on answer

nevilledhamsiri — Sat, 12 Aug 2017 17:49:29 GMT

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 — Mon, 14 Aug 2017 18:02:19 GMT

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