Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sunil_Kenth
Former Employee
Former Employee

Exclude blank cells in data

Hi,

What is the syntax to exclude null values in my data?  The field is called DFLOW?

Thanks,

Sunil

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

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

View solution in original post

7 Replies
Sunil_Kenth
Former Employee
Former Employee
Author

This is in my load script by the way.

Thanks,

Sunil

Miguel_Angel_Baeyens

Hi Sunil,

I prefer to use

Table:

LOAD *,

     If(Len(Field) = 0, 'Null', Field) AS Field

... // source here

Hope that helps.

Miguel

Sunil_Kenth
Former Employee
Former Employee
Author

Hi Miguel,

Thanks but I want to exlude the blank values and not specify them as a field.

Something like:

Where DFLOW <> ‘ ‘ .

jvitantonio
Luminary Alumni
Luminary Alumni

The you should do right that. Use a where close after the Load statement.

Sunil_Kenth
Former Employee
Former Employee
Author

Thanks but i need to know the exact syntax to write?

jvitantonio
Luminary Alumni
Luminary Alumni

Load * from youtfile.qvd (qvd)

Where DFLOW <> ' ';

Miguel_Angel_Baeyens

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