Script not working for Recoding Software into Soft

[paulyeo11]

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 · Accepted solution]

Remove , after SOFT 'SOFT',

   if (PRODUCT_TYPE='SOFTWARE','SOFT'

    ) as [PRODUCT_CLASS],

[paulyeo11]

Hi Sir

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

Thank you

Paul