Page Comparison

Label*

String

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.

Default Value: N/A
Example: ELT String functions Account

Pass through

Checkbox

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

String Unary Functions

Specify your arithmetic string 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 fieldset consists of the following fields:

• Function

• Argument

• Alias

Function*

String/Suggestion

Select an arithmetic unary expression/function to use. Click the Suggest icon to retrieve the list of the supported 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.

Default Value: None.
Example: PARSE_URL

Argument*

String/Expression

Each of the arithmetic unary 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: https://www.snaplogic.com

Alias Name*

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: PRL

String Binary Functions

Specify your arithmetic binary string 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 fieldset consists of the following fields:

• Function

• Argument 1

• Argument 2

• Alias

Function*

String/Suggestion

Select an binary expression/function to use. Click the Suggest icon to retrieve the list of the supported 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.

Default Value: None.
Example: SPLIT

Argument 1*

String/Expression

Each of the binary 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: LAT

Argument 2*

String/Expression

Each of the binary 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. You can skip this argument by entering the quotes if you want to leave it empty.
Default Value: None.
Example: LAT

Alias Name*

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: SPL

String Ternary Functions

Specify your arithmetic ternary string 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 fieldset consists of the following fields:

• Function

• Argument 1

• Argument 2

• Argument 3

• Alias

Function*

String/Expression

Select a ternary expression/function to use. Click the Suggest icon to retrieve the list of the supported 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.

Default Value: None.
Example: POSITION

Argument 1*

String/Expression

Each of the ternary functions needs three 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: e

Argument 2*

String/Expression

Specify the second argument in this field for the selected expression/function. This is typically a column name in your source table. You can skip this argument by entering the quotes if you want to leave it empty.
Default Value: None.
Example: DPT

Argument 3*

String/Expression

Specify the third argument in this field for the selected expression/function. This is typically a column name in your source table. You can skip this argument by entering the quotes if you want to leave it empty.
Default Value: None.
Example: 1

Alias Name*

String

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

Default Value: None.
Example: PST

Function*

String

Specify your arithmetic quaternary string 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 fieldset consists of the following fields:

/Expression

Select a quaternary expression/function to use. Click the Suggest icon to retrieve the list of the supported 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.

Default Value: None.
Example: INSERT

Argument 1*

String/Expression

Each of the quaternary functions needs four 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: DPT

Argument 2*

String/Expression

Specify the second argument in this field for the selected expression/function. This is typically a column name in your source table. You can skip this argument by entering the quotes if you want to leave it empty.
Default Value: None.
Example: 2

Argument 3*

String/Expression

Specify the third argument in this field for the selected expression/function. This is typically a column name in your source table. You can skip this argument by entering the quotes if you want to leave it empty.
Default Value: None.
Example: 1

Argument 4*

String/Expression

Specify the fourth argument in this field for the selected expression/function. This is typically a column name in your source table. You can skip this argument by entering the quotes if you want to leave it empty.
Default Value: None.
Example: e

Alias Name*

String

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

Default Value: None.
Example: INS