Value label how to remove 0 ?

paulyeo11 — Mon, 14 Sep 2020 09:42:55 GMT

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

Re: Value label how to remove 0 ?

jmmolero — Mon, 14 Sep 2020 10:13:00 GMT

hi,

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

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