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

[sunny_talwar]

there is an other sub category coming for OTC which is underlined above.

Not sure I understand, do you mind showing an example?

[bc-thebruuu]

May you share an app?

I would suggest to add the subcategory OTC as a main category ... or main_category_bis in order to not polute existing data