This content has been marked as final. Show 5 replies
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
if(len(MISC_feature_ID) > 1,1,0) as Len
from 'QVDTable*' (qvd);
where Len = 1;
Still whole data gets loaded in Table2
Can any one help me to get ride of blank values.