Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
What is the syntax to exclude null values in my data? The field is called DFLOW?
Thanks,
Sunil
Hi,
Elaborating on my example above
Table:
LOAD *,
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.
Hope that helps.
Miguel
This is in my load script by the way.
Thanks,
Sunil
Hi Sunil,
I prefer to use
Table:
LOAD *,
If(Len(Field) = 0, 'Null', Field) AS Field
... // source here
Hope that helps.
Miguel
Hi Miguel,
Thanks but I want to exlude the blank values and not specify them as a field.
Something like:
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 <> ' ';
Hi,
Elaborating on my example above
Table:
LOAD *,
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.
Hope that helps.
Miguel