How to show null values as zero?

[#1]

How to show null values as zero by script?

Ex: If COMM=NULL then 0 else COMM

[sushil353]

Hi,

Try:

if(isnull(Comm),0,comm) as fieldname

HTH

Sushil

[vivek_niti]

Hi,

Try this code

If(IsNull(COMM),0,COMM)

Regards,

Vivek

[its_anandrjs]

Hi,

You can try with

Load
If(Len(Trim(COMM))=0,0,COMM) as CommField
FRom Source;

And also

Load
If( Isnull(COMM)=-1,0,COMM) as CommField
FRom Source;

Regards

Anand

[lironbaram]

you can also use

this command

NullAsValue COMM;

Set NullValue =0 ;

your table load

and then

NullAsNull

[#6]

Not working any of the code.

[sushil353 · Accepted solution]

Hi,

Have u tried:

IF(COMM = 'NULL',0,COMM) as FieldName

HTH

Sushil

[#8]

Thank you all.

[engishfaque]

Dear JJR,

Convert null values to 0 using simple expression,

=Alt(FieldName, '',0)

Kind regards,

Ishfaque Ahmed

[its_anandrjs]

Hi,

It seems you have to convert 0 to NULL if so assume this example

New:
LOAD COMM,ID,If(Trim(COMM)=0,'NULL',COMM) AS FilterField;
LOAD * Inline [
COMM,ID
NULL,1
NULL,2
NULL,3
0,4
300,5
500,7
1400,7  ];

Regards

Anand