how to get the sub category in table column

[vishalgoud]

Hi all,

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

[felipedl]

If I understood your problem, you could write your case with the Match statement

Load

     if(match(MRC_TYPE,'MRC', 'MRC DISCOUNT', 'MRC REFUND', 'OCC', 'OTC', 'Data Pass','BOLT ON', 'Roaming Data Pass',MRC_TYPE) as Type

From [Whatever]

Didn't understand what you meant about the OTC, care to explain some more?

Felipe.