How to eliminate nulls from the fact at script level

[#1]

Hello everyone,

Can anybody tell me, How to eliminate nulls from the fact at script level,

Thanks

[miikkaqlick]

Hi!

For example like this:

Load

     Dim1

     Val2

     If( IsNull(Val3), 0, Val3) as Val3

From ...

Br,

Miikka

Climber

[JonnyPoole]

The LOAD syntax supports WHERE clauses.  Use NOT and isnull() as follows.  If you use SQL you should do the equivalent syntax in the SQL Where clause instead to reduce network traffic.

Load

     field1,

     field2,

     field3

from <>

where  NOT ( isnull(field1) or isnull(field2) or isnull(field3) ) ;

[#4]

Hi,

assume that

If you have null values in salesValue filed then use this

Load *,

Alt(SalesValue,0) as Sales_Value

from tablename;