delete nul values

[MauriceLudo]

Hi,

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

thank you.

Best regards

Maurice

[Gysbert_Wassenaar]

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:

• The Importance of Nothing
• Finding NULL
• NULL – The Invisible Nothing

[ganeshsvm]

You can use in your load script like this,

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

from "Sourcepath"

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

[#4]

Or the condition:
WHERE fieldname IS NOT NULL;

[#5]

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