Please help on handling nulls

[Anonymous]

Hi Experts,

I am having 2 fields  in table. how to achieve the ouput as it should remove the values if both fields has 0

Input Table:

FieldA	FieldsB
1	1
0	0
0	1
1	0

Output:

FieldA	FieldB
1	1
0	1
1	0

[kenphamvn]

Hi

Using where condition when load table

Load
FieldA,FieldB
Resident TABLE_NAME
WHERE FieldA <>0 and FieldB <>0;

if FieldA, FieldB =Null

Using Len(FieldA) <>0 or Len(FieldB) <>0

Regards,

An Pham

[siddharth_s3 · Accepted solution]

LOAD

Field A,

Field B

FROM LIB:\\ExcelFile

WHERE IF(FieldA = 0 AND FieldB = 0 ,1,0) =0

[Anonymous]

Hi Pham,

Thanks for your reply, I am not getting as expected by where condition.

Is any other way to do this?

[Anonymous]

Hi Siddharth,

Thanks for your reply. But its not working for me.