expr

[smilingjohn]

Hi All,

Hi in the script level iam trying to replace the null va;ues in Dept by brand , can anyone suggest if below statement is correct ?

if(IsNull(Dept),'brand',Dept),

[tresesco · Accepted solution]

Try like:

if(IsNull(Dept),'brand',Dept) as Fieldname

Or, better to deal with not-null spaces or other invisible characters try like:

if(Len(Trim(Dept))=0,'brand',Dept) as Fieldname

Assuming Dept is a field and you want it's value to be called as 'brand'.

[smilingjohn]

Yes Dept is a field and when ever there is null value in Dept it should be named as brand, if no null then as it is .

[tresesco]

Have you tried the above solutions?

[nitin_01]

Hi Tresesco,

            if(Len(Trim(Dept))>0,'brand',Dept) as Fieldname

with all respect, i'am perplexed with above condition that would give a desired output.

That shud be '=0' or '>0' ?

Regards,

Nitin.

[tresesco]

You are spot on. Corrected my post above.

[nitin_01]

hahah...

we follow you..:)

Regards,

Nitin.

[aapurva09]

Hi,

try this:

if(len(Dept)<=0,'brand',Dept)

Thanks

[#9]

Try this    If(len(Dept)=0,Brand,Dept) as NewField,

Let me know if this is working else I will provide other solution.

Thanks

jaydeep

[smilingjohn]

Hi tressco

you first statement worked fine

if(IsNull(Dept),'brand',Dept) as Fieldname