Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Why is this expression
if( IsNull(OPNTIJD)=0,OPNTIJD,0.33333)
working well as normal expression but not working when i do this in the script
as below.
LOAD
OPNDAT,
OPNTIJD,
if( IsNull(OPNTIJD)=0,OPNTIJD,0.33333) as ADMDAT
Resident BEDOCUP;
My goal is to replace zero value´s into 08:00 hour preferable is to do this in the script.
THANKS IN ADVACE!!
Try this:
LOAD
OPNDAT,
OPNTIJD,
if( IsNull(OPNTIJD), 0.33333, OPNTIJD) as ADMDAT
Resident BEDOCUP
Are the values to change definitely Nulls and not zeros?
please try this script
if(len(trim(OPNTIJD))=0,0.33333,OPNTIJD) as OPNTIJD
Yes absolutly nulls and not zero's
No unfortunatly ït is not working
Try this:
LOAD
OPNDAT,
OPNTIJD,
if( IsNull(OPNTIJD), 0.33333, OPNTIJD) as ADMDAT
Resident BEDOCUP
Masha's right - you're IsNull() is reversed! 0=False, -1 or nothing = True.
THANKS THIS WORKS WELL