Conditional functions

This page goes over the conditional functions in Upsolver.

COALESCE

Returns the first value that is not null or missing.

inputs	result
"Foo"	"Foo"
"Foo", "Bar"	"Foo"
null, "Foo", null, "Bar"	"Foo"
"Foo", null, "Bar"	"Foo"

IF_ELSE

If there is a true boolean value in the condition parameter then return the first value. Otherwise, return the second.

Inputs

• condition

• true_value

• false_value

condition	true_value	false_value	result
true	"foo"	"bar"	"foo"
false	"foo"	"bar"	"bar"
	"foo"	"bar"	"bar"

NULL_IF

If there is a true boolean value in the condition parameter, then return null. Otherwise, return the value.

Inputs

• condition

• value

condition	value	result
true	"foo"	null
false	"foo"	"foo"
	"foo"	"foo"