View Source

Returns true if the first argument is equal to the second argument. Equivalent to the = operator.

Each argument can be a literal String, Integer or Decimal number, a function, or a column reference.

Since the function returns a Boolean value, it can be used as a function or a conditional.

NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Comparison Operators.

if(equal(errorCount, 0),'ok','Error_recorded')

Output: If the value in the errorCount column is zero, then the status column value is ok. Otherwise, the value is Error_recorded.

equal(value1, value2)

Argument	Required?	Data Type	Description
value1	Y	string	The first value. This value can be a String, a number, a function, or a column reference.
value2	Y	string	The second value. This value can be a String, a number, a function, or a column reference.

value1, value2

Names of the columns, expressions, or literals to compare.

Missing values generate missing string results.

Required?	Data Type	Example Value
Yes	Column reference, function, or numeric or String value	`myColumn`

value1, value2

Example - Basic Equal and Notequal Functions