if(condition: bool, ontrue: storable, onfalse: ontrue) -> ontrue

Test if a condition is true or false.

Return the second argument if condition is true, otherwise return third argument. Arguments must have the same general type.

Domain

This is a scalar function (calculates a single output value for a single input row).

Categories

• Misc

Examples

filter b=if(a=true, 'foo', 'bar')

Filter input to rows where b is equal to 'foo' if 'a' is true and 'bar' otherwise