How to remove Blank values ?

[#1]

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.

[prieper]

are you sure that field is really empty?

syntax should be:

LOAD * FROM ....

WHERE LEN(TRIM(MyField));

Peter

[#3]

Yes Peter,

field is empty.

I tried with Trim() also.

Still blank data is loading

Regards,

Deepika

[prieper]

Then please post some sample data.

[beck_bakytbek]

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

[#6]

delete (table name)

where isnull(column name )