mvSQL database function - Differ()¶
Summary¶
Checks if both arguments match, if they do, App Builder outputs one of them, if they don't App Builder formats it so it looks like Value -----> New Value
Syntax¶
Differ (<string1>, <string2>)
Parameters¶
<string1>
The first string to evaluate
<string2>
The second string to evaluate
Returns¶
Evaluates the strings and returns either one if they match or formats the output if they are different
Examples¶
Differ(ColumnA, ColumnB)
if both columns have the same value it outputs (assuming ColumnA is Value
): Value
if both columns have different values it outputs (assuming ColumnB is New Value
): Value -----> New Value