Sequence Generator Processor
Sequence Generator processor allows you to generate a unique id for all the records generated by the processor. In other words, for generation of sequence in pipeline.
This processor will generate sequence in a field which can be used further in a pipeline.
Sequence Processor Configuration
To add a Sequence processor to your pipeline, drag the processor onto the canvas and right-click on it to configure.
There are three options to generate the type of sequence for the records.
| Field | Description |
|---|---|
| Type | Sequence: Generates numeric sequence of values. Composite Key: The combination of fields selected in order will serve as primary key. UUID: The generated random alphanumeric 128 bit sequences. |
| Output Field Name | Output Field name. |
Now, in case of Sequence, the following properties will be generated:
| Field | Description |
|---|---|
| Type | Sequence: Generates numeric sequence of values. |
| Output Field Name | Output Field name. |
| Start Value | First value to be generated, default is 0. |
| Increment By | Increment the value by the value entered in this field. Default is 1. |
| Cycle | If enabled, sequence values cycle through the range of start to end values. If disabled tasks will fail if end value reached and rows remain to process. |
| End Value | Maximum value to be generated (inclusive) after that value from start value will be generated. |
| Reset | If Reset is selected, the sequence will be generated after the last sequence (value) is generated. This field will not be a part of auto-inspection. |
In case of Composite Key, the following properties will be generated:
| Field | Description |
|---|---|
| Type | Composite Key: The combination of fields selected in order will serve as primary key. |
| Output Field Name | Output Field name. |
| Select Fields | Keys will be created in the order of the selection of the fields. |
| Field Separator | Separator for the field values. |
If you have any feedback on Gathr documentation, please email us!