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 of an if statement. Similar to an if statement, the first condition that evaluates to true has its value set into the provided target path. No other conditions are evaluated after one condition evaluates to true. If no conditions evaluate to true, then the default value (if set) is written to its provided target path. However, the Snap evaluates all conditions and writes return values to the Condition's corresponding target path if the Evaluate all property is set.

Conditions and return values are created using the expression language defined here.

If no condition is set, no data can flow through.

Snap Type

Conditional Snap is a TRANSFORM-type Snap that mimics an IF statement, evaluates conditions, and writes return values to the target path.

Prerequisites

None.

Support for Ultra Pipelines

Works in Ultra Pipelines.

Limitations and Known Issues

None.

Snap Views

Type	Format	Number of Views	Examples of Upstream and Downstream Snaps

Type

Format

Number of Views

Examples of Upstream and Downstream Snaps

Input

Document

Min: 1
Max: 1

Mapper
Copy

Output

Document

Min: 1
Max: 1

Mapper
Copy
Aggregate
Conditional
Router

Error

Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter while running the Pipeline by choosing one of the following options from the When errors occur list under the Views tab. The available options are:

Stop Pipeline Execution: Stops the current pipeline execution when the Snap encounters an error.
Discard Error Data and Continue: Ignores the error, discards that record, and continues with the rest of the records.
Route Error Data to Error View: Routes the error data to an error view without stopping the Snap execution.

Learn more about Error handling in Pipelines.

Snap Settings

Asterisk (*): Indicates a mandatory field.
Suggestion icon (): Indicates a list that is dynamically populated based on the configuration.
Expression icon (): Indicates whether the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.
Add icon ( ): Indicates that you can add fields in the field set.
Remove icon (): Indicates that you can remove fields from the field set.

Field Name		Field Type	Description

Field Name		Field Type	Description
Label* Default Value: Conditional Example: Conditional_test		String	Specify the name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your Pipeline.
Evaluate all Default Value: Deselected Example: Selected		Checkbox	Select this checkbox to evaluate all the conditions and writes all the return values to the target paths if the conditions evaluates to true. For example, select this checkbox, and select the condition as specified below: Conditional expression: $State == "CA" Return value: "California" Target path: $FullName Conditional expression: $id == 1 Return value: "found" Target path: $status If the input document has the following values: `{ State: "CA", id: 1 }` then the output document displays as below: `{ State: "CA", id: 1, FullName: "California", status: "found" }` because both conditions evaluate to true.
Null-safe access		Checkbox	Select if you want to set the target value to null in case the source path does not exist. If you do not select this checkbox, then the Snap fails if the source path does not exist, ignores the record entirely, or writes the record to the error view depending on the setting of the error view property For example, if you set the condition as $person.phonenumbers.pop() and target as $ lastphonenumber and do not select this checkbox, then it might result in an error in case person.phonenumbers does not exist on the source data. If you select this checkbox, then this option allows to write null to lastphonenumber.
Conditional table	Use this fieldset to specify the if conditions. For example, the following if statement: `if($State == "CA") {` `return "California";` `} else if ($State == "NJ") {` `return "New Jersey";` `}` can be given as these conditions: Condition1 Conditional expression: $State == "CA" Return value: "California" Target path: $FullName Condition2 Conditional expression: $State == "NJ" Return value: "New Jersey" Target path: $FullName
	Conditional expression* Default Value: None. Example: $State == "CA"	String/Expression	Specify the Conditional expression in this field based on which the Snap evaluates the condition.
	Return value Default Value: None. Example: California	String	Specify the value for the condition.
	Target path Default Value: None. Example: $FullName	String	Specify the target path to which the return value has to be written.
Default value Default Value: None. Example: N/A		String	Specify the default value to assign if none of the conditions evaluate to true, else statement. For example: `else {` `return "N/A";` `}`
Default value path Default Value: None. Example: $FullName		String	Specify the target path to which the return value has to be written when none of the conditions evaluate to true.
Snap Execution Default Value: Validate & Execute Example: Disabled		Dropdown list	Select one of the three modes in which the Snap executes. Available options are: Validate & Execute: Performs limited execution of the Snap, and generates a data preview during Pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during Pipeline runtime. Execute only: Performs full execution of the Snap during Pipeline execution without generating preview data. Disabled: Disables the Snap and all Snaps that are downstream from it.

SnapLogic Documentation

Conditional