Null +value

[soniasweety]

Hi All,

Quy Nguyen

youssef belloum

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?

[YoussefBelloum · Accepted solution]

Hi,

try like this:

table:

load

if(len(trim(GO_TO_MAR)=0,'Direct', GO_TO_MAR) as GO_TO_MAR

from...

[Frank_Hartmann]

if(len(trim(GO_TO_MAR))=0,'Direct', GO_TO_MAR) as GO_TO_MAR

[soniasweety]

thank you both its working fine