topic Re: delete nul values in QlikView

delete nul values

MauriceLudo — Fri, 30 Dec 2016 09:20:37 GMT

Hi,

Please i like delete nul values in the script, how i can do

thank you.

Best regards

Maurice

Gysbert_Wassenaar — Fri, 30 Dec 2016 09:33:42 GMT

By not loading them in the first place.

SQL SELECT ...stufff ... FROM ...somewhere.... WHERE ...something... Is Not Null ;
LOAD ...stufff ... FROM ...somewhere.... WHERE Not IsNull(...something...) ;

You may want to read these blog posts:

ganeshsvm — Fri, 30 Dec 2016 09:35:29 GMT

You can use in your load script like this,

LOAD field1, field2,.......

from "Sourcepath"

where len(trim(fieldname))<>0;

Fri, 30 Dec 2016 11:35:51 GMT

Or the condition:
WHERE fieldname IS NOT NULL;

Fri, 30 Dec 2016 11:37:14 GMT

Sorry, didn´t see the first answer, it was already stated