HIde All field has to value

[bsbernabe]

Hello There,

How to hide the field has to value?

ex.

Data                       |                    Value
064500000                                 NL
064500001
064500002                                 SL
064500003

the output should be like below, how can I do that?

Data                         |                   Value
064500001
064500003

Best Regards,

Bing

[Taoufiq_Zarra · Accepted solution]

@bsbernabe 

May be :

Data:
LOAD * INLINE [
    Data,Value
    064500000,NL
    064500001,
    064500002,SL
    064500003,
];

output:
noconcatenate
load * resident Data where len(Value)=0;

drop table Data;

output :

[Saravanan_Desingh]

One solution is.

tab1:
LOAD *
Where IsNull(Value) Or Value='' Or Len(Value)=0;
LOAD * INLINE [
    Data,Value
    064500000,NL
    064500001,
    064500002,SL
    064500003,
];

[Saravanan_Desingh]