What is the syntax to exclude null values in my data? The field is called DFLOW?
This is in my load script by the way.
I prefer to use
If(Len(Field) = 0, 'Null', Field) AS Field
... // source here
Hope that helps.
Thanks but I want to exlude the blank values and not specify them as a field.
Where DFLOW <> ‘ ‘ .
The you should do right that. Use a where close after the Load statement.
Thanks but i need to know the exact syntax to write?
Load * from youtfile.qvd (qvd)
Where DFLOW <> ' ';
Elaborating on my example above
FROM File.qvd (qvd)
WHERE Len(Field); // greater than zero means true, so load all where Field is not null
You can use any other SQL function, but it will depend on your ODBC driver and your database manager.
Retrieving data ...