Value label how to remove 0 ?

[paulyeo11]

Hi All

I have load script below :-

map_opt:
mapping LOAD *
Inline [
OPT, OPT_
1 ,Y
2 ,N

] ;

ApplyMap('map_opt', wildmatch( [Email Opt Out], 'TRUE*','FALSE*','LOA*')) as OPT_OUT,

Result i get is below :-

May i know how to make it only N and Y ? Meaning i want to remove 0

Because 0 only have 1 items. i can delete it.

Paul

[jmmolero · Accepted solution]

hi,

you can set "null()" as third parameter at applymap

ApplyMap('map_opt', wildmatch( [Email Opt Out], 'TRUE*','FALSE*','LOA*') ,null()) as OPT_OUT,