Overview

You can use this Snap to mimic an IF statement in most programming languages. Each row of the conditional table is equivalent to an if/else if block in an if statement. The Default value property is equivalent to the else block. The first condition that evaluates to true has its value set into the provided target path, and no other conditions are evaluated. If no conditions evaluate to true, the default value (if set) is written. If Evaluate all is selected, the Snap evaluates all conditions and writes return values to their corresponding target paths.

Conditions, return values, and default values are written using the SnapLogic expression language. Target paths are static strings and do not support expressions. If no condition is set, no data flows through.

• This is a Transform-type Snap.
• Works in Ultra Tasks

Snap views

Snap settings

{
    State: "CA",
    id: 1
}

{
    State: "CA",
    id: 1,
    FullName: "California",
    status: "found"
}

if($State == "CA") {
return "California";
} else if ($State == "NJ") {
return "New Jersey";
}

else {
return "N/A";
}