Add Sequence
Description
Add Sequence generates an incrementing integer value and adds it as a new field to each row in the data stream. Use this step when you need unique row identifiers, surrogate keys, or sequential numbering — for example, assigning line numbers to records before output or generating primary key values for database inserts. The sequence can be generated by a database sequence object or by an internal Process Studio counter, with configurable start, increment, and maximum values.
Configurations
| Field Name | Description |
|---|---|
| Step name | Specify the name of this step as it appears in the workflow workspace. This name must be unique within a single workflow. |
| Name of value | Specify the name of the new sequence value that is added to the stream. |
| Use DB to generate the sequence | Enable if you want the sequence to be driven by a database sequence, then set these parameters: Connection name, Schema name (optional), Sequence name. |
| Connection name | Specify the name of the connection on which the database sequence resides. |
| Schema name (optional) | Specify the table's schema name. |
| Sequence name | Specify the name of the database sequence. |
| Use a workflow counter to generate the sequence | Enable if you want the sequence to be generated by Process Studio, and then set these parameters: Counter name (optional), Start at, Increment by, Maximum value. |
| Counter name (optional) | If multiple steps in a workflow generate the same value name, this option enables you to specify the name of the counter to associate with. Avoids forcing unique sequencing across multiple steps. |
| Start at | Specify the value to begin the sequence with. |
| Increment by | Specify the amount/number by which the sequence increases or decreases. |
| Maximum value | Specify the value after which the sequence returns to the Start At value. |