Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In a load script I was hoping there would be a quick way to determine whether a numeric value falls within a range.
Something like
if( 0> myfield <1, 'BetweenZeroOne', 'NotBetween') as myfield2
something like inDay() which "returns true if timestamp lies inside the part of day containing basetimestamp up until and including the exact millisecond of basetimestamp".
hi,
try out this.
load myfield,if( myfield>=0 and myfield<=1, 'BetweenZeroOne', 'NotBetween') as myfield2
thanks
hi,
try out this.
load myfield,if( myfield>=0 and myfield<=1, 'BetweenZeroOne', 'NotBetween') as myfield2
thanks
hi,
try out this.
load myfield,if( myfield>0 and myfield<1, 'BetweenZeroOne', 'NotBetween') as myfield2
thanks