Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
are you sure that field is really empty?
syntax should be:
LOAD * FROM ....
WHERE LEN(TRIM(MyField));
Peter
Yes Peter,
field is empty.
I tried with Trim() also.
Still blank data is loading
Regards,
Deepika
Then please post some sample data.
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
delete (table name)
where isnull(column name )