Discussion board where members can get started with Qlik Sense.
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.
are you sure that field is really empty?
syntax should be:
LOAD * FROM ....
field is empty.
I tried with Trim() also.
Still blank data is loading
Then please post some sample data.
look at this blogs:
i hope that helps to resolve your issue
delete (table name)
where isnull(column name )