if¶

Description¶

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

least common generalization skipping variants

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

if( condition, ontrue, onfalse )

Argument	Type	Required	Multiple	Constant
condition	bool	Required	Only one	Variable
ontrue	variant	Required	Only one	Variable
onfalse	variant	Required	Only one	Variable

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

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