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

Overview

This Snap is used to generate a sequence of numbers. This sequence can start at any positive or negative integer and continue to provide new numbers by adding the step value to the previously generated number. 

The Snap does not require any input. However, if input is passed, it generates a sequence where the number of output documents is equal to the number of input documents. 

Note
The Snap supports only pipeline parameters.

Input and Output

  • Expected input: Optional. A document containing the initial value of the sequence and the increment value that you want to use to create the sequence.
  • Expected output: A document containing the sequence generated using the input parameters.
  • Expected upstream Snaps: Any Snap that offers documents. For example, JSON Parser, JSON Splitter, or Mapper.
  • Expected downstream Snaps: Any Snap that accepts documents. For example, Join, or a combination of JSON Formatter and File Writer.

Prerequisites

None.

Configuring Accounts

Accounts are not used with this Snap.

Configuring Views

Input

This Snap has at most one document input view.
OutputThis Snap has exactly one document output view.
ErrorThis Snap has at most one document error view.

Troubleshooting

  • None.

Limitations and Known Issues

None.

Modes

Ultra pipelines:

Support

  • Works in Ultra pipelines.Spark mode: Does not work in Spark mode

Known Issues

  • None.

Snap Settings


LabelRequired. The name for the Snap. Modify this to be more specific, especially if there are more than one of the same Snap in the pipeline.
Initial value

Required. The initial value of the sequence.

Example

  • 0
  • _initialValue

Default value: 1

Step value

Required. This property increments (or decrements if negative) the sequence value by this amount to produce the next sequence value.
Example

  • -1 (negative value)
  • 1 (positive value)
  • _stepValue

Default value: 1

Number of documentsRequired. The number of documents to generate.
Example
  • 10
  • _numberOfDocuments

Default value:  1

Note

The value in this property is ignored if an input dataset is provided to the Snap. In such cases, the number of documents in the output is equal to the number of documents in the input.


Pass through

Set this option to determine if input data should be passed through or not.

Default value: Not selected

Multiexcerpt include macro
nameSnap Execution
pageAnaplan Read


Multiexcerpt include macro
nameSnap_Execution_Introduced
pageAnaplan Read


Examples


Sequence Snap without Input

The pipeline, Sequence_Snap_Without_Input_Data, demonstrates a basic Sequence Snap without any input data. Upon execution, the Snap generates a sequence of numbers based on the Snap's settings.

Click here to download this pipeline. You can also downloaded this pipeline from the Downloads section below.


Expand
titleExplanation: Sequence Snap Without Input

The pipeline is as shown below:

The Sequence Snap is configured as shown below:

The initial value is -10 and this is incremented by 1 to output a total 50 records. The output from the Sequence Snap is a sequence of numbers -10, -9, -8, and so on, as shown below:


The downstream Snaps are configured to demonstrate a typical use case for the Sequence Snap. In this example, an Aggregate Snap, and two filter Snaps are used. The Aggregate Snap is configured to show the total number of records, and the Filter Snaps are configured to filter negative and positive integers. Their outputs are as shown below: 


Click here to download this Pipeline. You can also downloaded this pipeline from the Downloads section below.

Sequence Snap with Input

The pipeline, Sequence_Snap_with_Input_Data, demonstrates how the Sequence Snap functions when there is an input. Upon execution, the Snap generates a sequence of numbers based on the Snap's configuration. However, the number of records output by the Snap is the same as the number of input records.

Click here to download this pipeline. You can also downloaded this pipeline from the Downloads section below.


Expand
titleExplanation: Sequence Snap with input

The pipeline is as shown below:

The CSV Generator Snap passes a CSV file containing 9 records to the Sequence Snap, Sequence with Input. The other Sequence Snap, Sequence Without Input, is configured with the same values as the other Sequence Snap. Outputs from both Snaps are shown to demonstrate that the total records in the output vary according to the Snap's input. 

The input to the Sequence with Input Snap is as shown below:


The Sequence Snap is configured as shown below:


Based on the Snap's configuration, the output sequence starts from 1 with increments of 10. Even though the Number of documents property is configured as 1, the output contains a sequence of 9 records, same as the number of input records. The original data from the input is also shown under "original" in the output, you may use a Mapper Snap downstream to capture this original data as per your requirements.


The second Sequence Snap, Sequence Without input, is configured with the same values as the first Sequence Snap.

Based on the Snap's configuration, the output contains only one record, as shown below: 

This demonstrates that the number of records in the Sequence Snap's output depends on the number of records in the input. 

Click here to download this Pipeline. You can also downloaded this pipeline from the Downloads section below.


Downloads

Attachments
patterns*.slp,*.zip

Excerpt Include
Transform Snap Pack
Transform Snap Pack
nopaneltrue