Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

How to remove Blank values ?

Hi All,

I am trying to remove data from a qvd where field is blank.

I tried with below conditions,but it didn't work for me.

1) Where len(Field_Name) > 0

2) Where Trim(Field_Name) <> ''

Even i tried below steps  ,still it didn't work

3) loading data in a table with Len column and then load data in another table by applying condition

Table:

Load

if(len(MISC_feature_ID) > 1,1,0) as Len

from 'QVDTable*' (qvd);

Table2:

Load

Len

RESIDENT Table

     where Len = 1;

Still whole data gets loaded in Table2

Can any one help me to get ride of blank values.

5 Replies
prieper
Not applicable

Re: How to remove Blank values ?

are you sure that field is really empty?

syntax should be:

LOAD * FROM ....

WHERE LEN(TRIM(MyField));

Peter

Not applicable

Re: How to remove Blank values ?

Yes Peter,

field is empty.

I tried with Trim() also.

Still blank data is loading

Regards,

Deepika

prieper
Not applicable

Re: How to remove Blank values ?

Then please post some sample data.

beck_bakytbek
Not applicable

Re: How to remove Blank values ?

Hi Deepika,

look at this blogs:

1.https://www.youtube.com/watch?v=pGpdfMpmWoE

2. https://www.youtube.com/watch?v=l20fjOQgbRc

i hope that helps to resolve your issue

Beck

Not applicable

Re: How to remove Blank values ?

delete (table name)

where isnull(column name )