Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Please help on handling nulls

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:

FieldAFieldsB
11
00
01
10

Output:

FieldAFieldB
11
01
10
1 Solution

Accepted Solutions
siddharth_s3
Partner - Creator II
Partner - Creator II

LOAD

Field A,

Field B

FROM LIB:\\ExcelFile

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

View solution in original post

4 Replies
kenphamvn
Creator III
Creator III

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
Partner - Creator II
Partner - Creator II

LOAD

Field A,

Field B

FROM LIB:\\ExcelFile

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

Anonymous
Not applicable
Author

Hi Pham,

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

Is any other way to do this?

Anonymous
Not applicable
Author

Hi Siddharth,

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