Input 

Document

• Min: 1

• Max: 1

• ELT Select

• ELT Filter

• ELT Transform

A document containing the SQL query that yields the data required to perform the conditional (unary or binary) operations.

Output

Document

• Min: 1

• Max: 1

• ELT Select

• ELT Filter

• ELT Transform

• ELT Insert Select

A document containing the incremental SQL query that includes the conditional functions defined in the Snap.

Label*

String

Specify a unique label for the Snap.

Default Value: ELT Conditional Function
Example: Unary_Binary_Checks

Get preview data

Checkbox

Select this checkbox to include a preview of the query's output. The Snap performs limited execution and generates a data preview during Pipeline validation.

The number of records displayed in the preview (upon validation) is the smaller of the following:

• Number of records available upon execution of the SQL query generated by the Snap.

• The value set in the Preview Data Count setting (default is 50 records).

Default Value: Not selected
Example: Selected

Pass through

Checkbox

Select this checkbox to specify that the Snap must include the incoming document (SQL query) in its output document.

Default Value: Not selected
Example: Selected

Conditional Unary Functions

Specify your conditional unary function/operation to be performed on a single table column/its value, using this fieldset. Click to add a new row. Ensure that you specify each function in a separate row.

This field set consists of the following fields:

• Unary Conditional Expression Name

• Argument

• Alias

Unary Conditional Expression Name*

String/Suggestion

Select a unary expression/function to use. Click the Suggest icon to retrieve the list of the supported unary conditional functions. The list displays the functions supported by the database that you select in the Account settings. An error is displayed if an account is not configured.
You can use the following unary functions:

• BOOLNOT

• ISNOTNULL

• ISNULL

• NULLIFZERO

• ZEROIFNULL

Default Value: None.
Example: ISNULL

Argument*

String/Expression

Each of the unary conditional functions needs only one value/argument. Hence, specify an argument for the selected expression/function. This is typically a column name in your source table.
Default Value: None.
Example: ORDER_ID

Alias*

String

Specify the column in which to display the result of the unary function. You can also reference this name in downstream Snaps to process the data further. 

Default Value: None.
Example: A_OID

Conditional Binary Functions

Specify your conditional binary function/operation to be performed on any two table columns/their values, using this fieldset. Click to add a new row. Ensure that you specify each function in a separate row.

This field set consists of the following fields:

• Binary Conditional Expression Name

• First Argument

• Second Argument

• Alias

Binary Conditional Expression Name*

String/Suggestion

Select a binary expression/function to use. Click the Suggest icon to retrieve the list of the supported binary conditional functions. The list displays the functions supported by the database that you select in the Account settings. An error is displayed if an account is not configured.
You can use the following binary functions:

• BOOLAND

• BOOLOR

• BOOLXOR

• EQUAL_NULL

• NULLIF

• NVL

• REGR_VALX

• REGR_VALY

Default Value: None.
Example: NVL

First Argument*

String/Expression

Each of the binary conditional functions needs two values/arguments. Specify the first argument in this field for the selected expression/function. This is typically a column name in your source table.
Default Value: None.
Example: ORDER_ID

Second Argument*

String/Expression

Each of the binary conditional functions needs two values/arguments. Specify the second argument in this field for the selected expression/function. This is typically a column name in your source table.
Default Value: None.
Example: ORDER_IDS

Alias*

String

Specify the column in which to display the result of the binary function. You can also reference this name in downstream Snaps to process the data further. 

Default Value: None.
Example: A_ORDIDS

Invalid placement of ELT Conditional Function snap

ELT Conditional Function Snap cannot be used at the start of a Pipeline.

Move the ELT Conditional Function Snap to either the middle or the end of the Pipeline.

Missing property value

You have not specified a value for the mandatory field where this message is displayed.

Ensure that you specify appropriate values for all mandatory fields in the Snap configuration.