nullIf

swordfish.function.nullIf()

• For two scalars, the function returns a null value if the values and data types of X and Y are equal. Otherwise, returns X.

• For two vectors of equal length, the function conducts the aforementioned calculation with each pair of elements in X and Y at the same position.

• For a scalar and a vector, the function conducts the aforementioned calculation on the scalar and each element of the vector.

Parameters:

• a (Constant) – Can be a scalar or vector, or an expression that returns a scalar or vector.

• b (Constant) – Can be a scalar or vector, or an expression that returns a scalar or vector.