5 Replies Latest reply: May 10, 2017 10:03 AM by tsotne shengelia RSS

    How to remove Blank values ?

    Deepika Shinde

      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.