Delete null values in the LOAD

[#1]

Hi everybody.

I have null values and i dont wanna see them.

Can i delete this values in the load statements?

for example

LOAD //id,

     num_web AS CodigoWeb,

     coditm AS Articulo,

     precio,

     //cant,

     asignado AS CantidadAdjudicada

WHERE nobody of this columns have null values?

THANK you all!

[MarcoWedel]

Where not (isnull(field1) or isnull(field2) or ...)

[albertovarela]

Intenta esto:

[MarcoWedel]

Please close thread if your question is answered.

Thanks

Regards

Marco

[#5]

Dont know why i can´t put correct answer!

[MarcoWedel]

Hi,

it's OK, just saw your thread isn't opened as a question.

regards

Marco

[#7]

Ok. Sory for that. I´ll pay more atention the next time.

Cheers!