Expression if EMPTY VALUE or Null

[#1]

Hey guys,

Im reading an SQL query from and populating a table, which works fine!

Now I would like to set a where statement so to speak in an expression. so that rows onyl shows where my column: Registration isNull or has an empty value.

[#2]

I just want to show thw rows where Registration column is either NULL or has an empty value. Whenever it has a value don't show it in the table.

Is that clear enough sorry guys 😕

[Kushal_Chawda]

try

LOAD *

FROM Table.qvd(qvd)

where isnull(Registration) or len(trim(Registration))=0;

[#4]

Yeah this si exactly what I want to achieve. Thing is Im loading from a SQL script not a QVD. that's why I was looking to make this in an expression.

[Kushal_Chawda]

Table:

LOAD *

where isnull(Registration) or len(trim(Registration))=0;

SQL SELECT *

FROM TABLE;

[#6]

That script is not useful for that first we have to check what type of database we are using  oracle and sql server I found one

of the best sollution video hope it"s really helpful for you https://www.youtube.com/watch?v=8olMt2AOUJ8