Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have field called Go_to the values i can see is
blank
direct
indirect
so my requirment is all null.blank treat as direct only
how can i do this?
Hi,
try like this:
table:
load
if(len(trim(GO_TO_MAR)=0,'Direct', GO_TO_MAR) as GO_TO_MAR
from...
Hi,
try like this:
table:
load
if(len(trim(GO_TO_MAR)=0,'Direct', GO_TO_MAR) as GO_TO_MAR
from...
if(len(trim(GO_TO_MAR))=0,'Direct', GO_TO_MAR) as GO_TO_MAR
thank you both its working fine