Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Could you please give examples Null() function. Thanks in advance.
Hi,
Null() returns a Null value wherever it is used, it is mainly used to assign a Null() value to a field/variable or to a expression.
Suppose,
vNullValue = Null()
It will assign Null Value to the variable.
Regards,
Jagan.
Are you going through the list of all functions?
I would suggest having a look at the HELP, the reference manual or searching the forum...
=IsNull( NULL() )
will return -1 (TRUE)
Hi swuehl
I read in help but unable to understand. Could you give some sample data example... Thank you.
NULLs:
LOAD IsNull(F1) as IsF1Null, F1;
LOAD If(F1< 0.25, NULL(),F1) as F1;
LOAD RAND() as F1
AutoGenerate 20;
And you already got this link, I recommend to go through each reference document:
Hi,
Null() returns a Null value wherever it is used, it is mainly used to assign a Null() value to a field/variable or to a expression.
Suppose,
vNullValue = Null()
It will assign Null Value to the variable.
Regards,
Jagan.