Remove Null Row

[Anonymous]

Hello qlikers,

My Table looks like:

Fruit          Comment
Apple        delicious
Banana     yellow
Grapes       -

- -> is Null, but i dont want the row with the grapes in my table.

So I'm creating a new table with a where clause.  But I cant find something similar like SQL statement Where Comment is Null. How can I "delete/remove" the row with the null? 

Thank you in advance. 

[bharathadde]

Try this 

Dimension

=if(not isnull(Comment),Fruit) -- (Check box suppress the null value)

Expression

=Comment

[marcus_sommer]

Try it with:

load ... from ... where len(trim(Comment));

- Marcus

[sugathirajkumar]

Dim 1 :- =if(Comment<>'-',AddFruit)

Dim 2  : Comment 

Suppress null value 

if you dont want to suppress null value then 

Dime 1:- =if(Comment<>'-',AddFruit)

Dim 2 :- =if(Comment<>'-',Comment)