topic Re: Re: Script not working for Recoding Software into Soft in QlikView

Script not working for Recoding Software into Soft

paulyeo11 — Fri, 13 Jun 2014 15:04:40 GMT

Hi All

I did a partial reload using the below script , but it does not work.

left join (GE)

Load PART_NO_,

if (PRODUCT_TYPE='SOFTWARE','SOFT',

) as [PRODUCT_CLASS],

Can some one advise where i go wrong ?

Paul

MK_QSL — Fri, 13 Jun 2014 15:06:10 GMT

Remove , after SOFT 'SOFT',

if (PRODUCT_TYPE='SOFTWARE','SOFT'

) as [PRODUCT_CLASS],

paulyeo11 — Fri, 13 Jun 2014 15:28:42 GMT

Hi Sir

it work now , as i spell Software as SOFTWARE . now it work.

Thank you

Paul