WHEN MRC_TYPE in ('MRC', 'MRC DISCOUNT', 'MRC REFUND', 'OCC', 'OTC', 'Data Pass','BOLT ON', 'Roaming Data Pass') then MRC_TYPE
in the above case statement which we are wirting in Qlikview (netezza code) , there is an other sub category coming for OTC which is underlined above.
how to bring that sub category of OTC as a main category like above..
any help on this is much appreciated. Thanks
If I understood your problem, you could write your case with the Match statement
if(match(MRC_TYPE,'MRC', 'MRC DISCOUNT', 'MRC REFUND', 'OCC', 'OTC', 'Data Pass','BOLT ON', 'Roaming Data Pass',MRC_TYPE) as Type
Didn't understand what you meant about the OTC, care to explain some more?