Removing Null values in the script?

[chinnu123]

Hi Community,

       In my data there are nulls I need to remove that null data in the script it self. i don't want to load that nulls data in to qlik.

  can any one suggest it how to achieve it?

Thanks in Advance

Regards,

Chinnu.

[swuehl]

LOAD Data

FROM ...

WHERE LEN(TRIM(Data));

or

LOAD

     IF(LEN(TRIM(Data)), Data, 'No data') AS Data

FROM ...;

[#3]

Chinnu,

Using Qlikview null functions we can handle this.

we can write a case logic like

if (isnull(fieldname)=-1,'No Data',fieldname) as fieldname.

But if instead of null if your data have space or anything besides null showing as null, use TRIM function as Swuehl mentioned above.

Thanks

Brad.

[chinnu123]

Hi swuehl,

Thanks for your quick reply,

I want to delete that null values data permanently instead of changing as some other name.

for example i have a field name ISSUES in this field i have some null values  '-' i want to remove that data permanently.

Regards,

Chinnu.

[swuehl · Accepted solution]

If you want to remove these records where ISSUES is NULL, then just use the WHERE clause:

LOAD ISSUES,

          AnotherField

FROM ...

WHERE LEN(TRIM(ISSUES));

[Anonymous]

Hi,

Load

Data..

from

where Field is not null;

Regards

[MarcoWedel]

Hi,

for "real" null values you could use:

...
Where not IsNull(YourField);

but that would not work for e.g. blanks or empty strings.

hope this helps

regards

Marco

[chinnu123]

Thanks Swuehl,

Its working...