Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this
Dimension
=if(not isnull(Comment),Fruit) -- (Check box suppress the null value)
Expression
=Comment
Try it with:
load ... from ... where len(trim(Comment));
- Marcus
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)