Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to exclude nulls from script.
Hi, Try the function IsNull(Field)
LOAD * from Table Where Not IsNull(Field);
Best Regards.
Tonial.
At the end of you script you can do somthing like
Where Len(fieldname) > 1
Hi,
To load without nulls I usually put:
Where not(IsNull(FieldName))
Also works, for nulls and empty strings:
Where Len(FieldName)>0
To also exclude empty spaces:
Where Len(Trim(FieldName))>0
A remark: when you load from qvd or Excel, you have real null values; when you load from csv or txt, you get empty strings instead, but 2nd and 3rd formula work.
Hope this helps.
Doesn’t work for my need.
Doesn’t work for my need.
Doesn’t work for my need.
Hi Paul,
What is the exact requirement?
In the example below, I do not want the PSalesNumber (example numbers below) 2705, 2702,2699, etc. to appear.
What does your load script for this data look like ?