Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
LOAD
Field A,
Field B
FROM LIB:\\ExcelFile
WHERE IF(FieldA = 0 AND FieldB = 0 ,1,0) =0
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
LOAD
Field A,
Field B
FROM LIB:\\ExcelFile
WHERE IF(FieldA = 0 AND FieldB = 0 ,1,0) =0
Hi Pham,
Thanks for your reply, I am not getting as expected by where condition.
Is any other way to do this?
Hi Siddharth,
Thanks for your reply. But its not working for me.