Differ() mvSQL database function in Jitterbit App Builder

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