Remove blank values from database in qlik sense

[vanand3535]

I have a field called REASON_MISSED_INJURY_ID in my database.

It has around 51437 values including null or blank.

I want to remove all the null and blank values from the database.

So How can I do this?

[MK_QSL]

While loading use something like below

LOAD F1, F2, F3 etc from tablename

where Not IsNull(REASON_MISSED_INJURY_ID) or Len(Trim(REASON_MISSED_INJURY_ID)) <> 0;

or

Select

F1, F2, F3

From YourDataBaseTable

Where Not  IsNull(REASON_MISSED_INJURY_ID);

[vanand3535]

I tried two syntaxes:-

len(REASON_MISSED_INJURY_ID )>0

and

trim(len(REASON_MISSED_INJURY_ID ))>0

[brunobertels]

Hi

try this with a where clause

table:

LOAD

    a,

    b,

     c

FROM source

WHERE len(REASON_MISSED_INJURY_ID)>0;

[sasiparupudi1]

Try

len(Trim(REASON_MISSED_INJURY_ID ))>0