If statement to evaluate in interval

[pduplessis]

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".

[#2 · Accepted solution]

hi,

try out this.

load myfield,if( myfield>=0 and myfield<=1, 'BetweenZeroOne', 'NotBetween') as myfield2

thanks

[#3]

hi,

try out this.

load myfield,if( myfield>0 and myfield<1, 'BetweenZeroOne', 'NotBetween') as myfield2

thanks