Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

On this Page

Table of Contents
maxLevel2
excludeOlder Versions|Additional Resources|Related Links|Related Information

...

Snap type:

...

Transform

...

Overview

This Snap sorts a document stream using its values in the order in which they show up in the sort path list. For example, if the sort paths are $first_name and $last_name, then the value at first_name will be used first when sorting.

This Snap uses temporary files to sort the input document streams and is limited by the size of the free disk space in a node. The Snap reads input documents and sorts them in a memory buffer. When the buffer size reaches a certain limit, it writes the data in the buffer into a temporary file, clears the buffer, and reads/sorts more input documents.

...

The minimum size of the memory buffer is 100MB. You can increase the value in the Maximum memory % field.

...

Snap Type

The Sort Snap is a Transform-type Snap that sorts the input document streams in the memory buffer.

Prerequisites

None.

Support

...

for Ultra Pipelines 

Does not

...

in Ultra Pipelines.

...

Accounts are not used with this Snap.

...

 

Limitations and Known Issues

None.

Snap Views

Type

Format

Number of Views

Examples of Upstream and Downstream Snaps

Description

Input 

Document

  • Min: 1

  • Max: 1

  • Mapper

  • Union

The Snap reads input documents and sorts them in a memory buffer.

Output

Document

  • Min: 1

  • Max: 1

  • Mapper

  • Join

This Snap sorts a document stream which show up in the sort path list.

Error

This Snap has at most one

...

document error view and produces zero or

...

more documents in the view.

Snap Settings

Info
  • Asterisk (*): Indicates a mandatory field.

  • Suggestion icon ((blue star)): Indicates a list that is dynamically populated based on the configuration.

  • Expression icon ( (blue star) ): Indicates the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.

  • Add icon ((blue star)): Indicates that you can add fields in the fieldset.

  • Remove icon ((blue star)): Indicates that you can remove fields from the fieldset.

Field Name

Field Type

Description

Label

String

Required. 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.

Sort Paths

Required. List of paths to sort on.

Sort path

Default Value: None

Example: $person.first_name

String/Sugesstion

Required. Paths of values in the document to sort on.

Sort order

Default value: global

Example:

...

ascending

Dropdown list

Required. Order of sorting. The available options are:

  • global

  • ascending

  • descending

...

Note

If you select the option global, the Sort order (Global) property becomes functional for the corresponding Sort path.

Sort order (Global)

Default value: ascending

Example: descending

Dropdown list

Sort the specified values in ascending or descending order.

Null greater

Default value:

...

Not Selected

Example: Selected

Checkbox

If selected, null is considered greater than non-null values, and null values will be placed last when sorted in the ascending order.

  • If selected and Sort order is ascending, nulls appear at the end of the list.

  • If selected and Sort order is descending, nulls appear at the beginning of the list.

  • If not selected and Sort order is ascending, nulls appear at the beginning of the list.

  • If not selected and Sort order is descending, nulls appear at the end of the list.

Please note that an empty string is not considered as null and always smaller than non-empty strings.

Null-safe access

Default value:

...

Selected (True)  

Example: Deselected

Checkbox

If selected, the Snap considers the values of non-existent or incorrect sort paths as null. If unselected, the Snap validates each input document to throw errors for non-existent or incorrect sort paths. Clearing this property will result in a lower performance.

Maximum memory %

Default value

...

: 10

Example: 20

Integer

Enter the percentage of maximum used memory compared to the maximum system memory. Sort Snap uses this property value to compute the size of the internal memory buffer for the external merge sort. The minimum buffer size is set to 100MB. If multiple instances of Sort Snap might be simultaneously being executed in the same Snaplex and the system memory size is limited, it is strongly advised to keep this property value low.

...

Default value: 10

...

Snap Execution

...

Dropdown list

Multiexcerpt include macro
nameSnap_Execution_Introduced
pageAnaplan Read

Multiexcerpt include macro
nameTemporary Files
pageJoin

Examples

...

Insert excerpt
Transform Snap Pack
Transform Snap Pack
nopaneltrue