topic Re: hi, in QlikView

hi,

Fri, 05 Jun 2015 02:39:34 GMT

my issue issue is I loaded a table , but it has null values or blank spaces in columns , i need to remove them , how can i do ?

can someone suggest me some expression or solution

pokassov — Fri, 05 Jun 2015 07:14:01 GMT

Hello

Load

...

from

...

where not isnull(your_field);

swuehl — Fri, 05 Jun 2015 09:07:02 GMT

To handle NULL as well as blanks, a common approach is to check against len(trim(FIELD)):

LOAD

FIELD,

AnotherFIELD

FROM TABLE

WHERE LEN(TRIM(FIELD));

Fri, 05 Jun 2015 13:53:29 GMT

Thanks for the solutions, I will try doing it