mvSQL Database Function - Differ()¶

Summary¶

Checks if both arguments match, if they do, Vinyl outputs one of them, if they don't Vinyl 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