Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Where not (isnull(field1) or isnull(field2) or ...)
Intenta esto:
Please close thread if your question is answered.
Thanks
Regards
Marco
Dont know why i can´t put correct answer!
Hi,
it's OK, just saw your thread isn't opened as a question.
regards
Marco
Ok. Sory for that. I´ll pay more atention the next time.
Cheers!