Returns |
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. |
Names of the columns, expressions, or literals to compare.
Required? | Data Type | Example Value |
---|---|---|
Yes | Column reference, function, or numeric or String value | myColumn |