Page Comparison

In this article

Table of Contents

maxLevel	4
minLevel	1
absoluteUrl	true
exclude	Older Versions\|Additional Resources\|Related Links\|Related Information

...

Field Name

Field Type

Description

Label*

Default Value: Mapper
Example: Mapper

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.

Null-safe access

Default Value: Deselected
Example: Selected

Checkbox

Select this checkbox to set the target value to null in case the source path does not exist. For example, $person.phonenumbers.pop() ->$ lastphonenumber may result in an error if person.phonenumbers does not exist in the source data. Selecting this checkbox allows the Snap to write null to lastphonenumber instead of displaying an error.
If you deselect this checkbox, 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 field.

Pass through

Default Value:Deselected
Example:Selected

Checkbox

This setting determines if data should be passed through or not.

If you select this checkbox, then all the original input data is passed into the output document together with the data transformation results.

If you deselect this checkbox, then only the data transformation results that are defined in the mapping section appear in the output document and the input data is discarded.

Note

This setting is impacted by Mapping Root. If Mapping Root is set to $ and Pass through is not selected, anything not mapped in the table will not pass through. However, if Mapping Root is set to $customer and Pass through is not selected, it will only apply to the items within the Mapping Root level. That means that anything above the Mapping Root level will pass though and items at the Mapping level that are not mapped in the table will not pass through.

When to always select Pass through

Always select Pass through if you plan to leave the Target path field blank; else, the Snap displays an error that the field that you want to delete does not exist. This is the expected behavior.

For example, you have an input file that contains a number of attributes; but you need only two of these downstream. So, you connect a Mapper to the downstream Snap supplying the input file, select the two attributes you need by listing them in the Expression fields, leave the Target path field blank, and select Pass through. When you execute the Pipeline, this Snap evaluates the input documents/binary data and picks up the two attributes that you want, and passes the entire document/binary data through to the Target schema. From the list of available attributes in the Target Schema, the Mapper Snap picks up the two attributes you listed in the Expression fields, and passes them as output. However, if you had not selected the Pass through checkbox, the Target Schema would be empty, and the Mapper would display a No schema available error.

Transformations*

Use this field set to configure the settings for data transformations.

Mapping Root

Default Value: $
Example: $

String/Suggestion

Specify the sub-section of the input data to be mapped. Learn More: Understanding the Mapping Root.

Input Schema

Dropdown list

Select the input data (that comes from the upstream Snap) that you want to transform. Drag the item you want to map and place it under the Mapping table.

Mapping table

Use this field set to specify the source path, expression, and target path columns used to map schema structure.

Expression

Default Value: N/A
Example: $first.concat(" ", $last)

String/Expression

Specify the expression to write to the target pathThe function to use to transform the data. For example, combine, concatenate or flatten. Expressions that are evaluated will remove replace the source targets at the end of the runPipeline runtime.

Note
Incoming fields from previous Snaps that are not expressly defined in the Mapping Table are passed through the Data Snap to the next Snap. However, when defining output fields in the Target Path, if the field name is the same as a field name that would otherwise Pass through, the field in the mapping table overrides the output.

Lear More: Understanding Expressions in SnapLogic and Using Expressions for usage guidelines.

Info

Managing Numeric Inputs in Mapper Expressions

While working with upstream numeric data, you may see some unexpected behavior. For example, consider a mapping that reads as follows:

Expression: $num +100
Target path: $numnew

For example, the value being passed from upstream for $num is 20.05. You would expect the value of $numnew to now be 120.05. But, when you execute the Snap, the value of $numnew is shown as 20.05100.

This happens because, as of now, the Mapper Snap reads all incoming data as strings, unless they are expressly listed as integers (INT) or decimals (FLOAT). So, to ensure that the upstream numeric data is appropriately interpreted, parse the data as a float. This will convert the numeric data into a decimal; and all calculations performed on the upstream data in the Mapper Snap will work as expected:

Expression: pareFloat($num1)+100
Target path: $numnew

The value of $numnew is now shown as 120.05.

Target path

Default Value: N/A
Example:

String/Suggestion

Specify the The target path at which the expression should be writtenJSON path where the value from the evaluated expression is written. For example, after evaluation of the $person.firstname expression the Snap inserts the firstname for the person object.

Target Path Recommendation

Info
Iris simplifies configuring the Target path property in this Snap by recommending suggestions for the Expression and Target path fields mapping. To make these suggestions, Iris analyzes Expression and Target path mappings in other Pipelines in your Org and suggests the exact matches for the Expressions in your current Pipeline. The suggestions are displayed upon clicking against the Target path.

For example, you have the Expression $Emp.Emp_Personal.FirstName in one of your Pipelines. And you have set the Target path for this expression as $FirstName. Now, if you use the expression $Emp.Emp_Personal.FirstName in a new Pipeline, then Iris suggests $FirstName as one of the recommended Target paths. This helps you standardize the naming standards within your org.

The following video illustrates how Iris recommends Target path in a Mapper Snap:

Snap Execution

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.

...

If the Escape Character is

Use Expression

Sample Output

Single quote (')

JSON:

$original.mapValues((value,key)=> value.toString().replaceAll("'","''"))

OR

$original.mapValues((value,key)=> value.toString().replaceAll("'","\''"))

CSV:

$[' Business-Name'].replace ("'","''")

Ampersand (&)

JSON:

$original.mapValues((value,key)=> value.toString().replaceAll("'","\&'"))

OR

$original.mapValues((value,key)=> value.toString().replaceAll("'","&'"))

CSV:

$[' Business-Name'].replace ("'","&'")

Backslash (\)

JSON:

$original.mapValues((value,key)=> value.toString().replaceAll("'","\\'"))

Info
Backslash is configured as an escape character in SnapLogic. Therefore, it must itself be escaped to be displayed as text.

CSV:

$[' Business-Name'].replace ("'","\\'")

In this way, you can customize the data to be passed on to downstream Snaps using the Expression field in the Mapper Snap.

...

Insert excerpt

	Transform Snap Pack
	Transform Snap Pack
nopanel	true

Versions Compared

Old Version 57

New Version 58

Key