Generate sequence
This function returns the extra parameter, and, for each row, will increase this number by 1.
This function can be applied on all data types but Date (Integer, Long, Strings, etc.).
Information noteNote: This function is not supported in the Spark version of the component.
| Option | Description |
|---|---|
| Extra parameter |
This function requires an extra parameter.
The extra parameter must be a number. If the extra parameter is not a number, it is set to 0. |
In the following example, the generated sequence starts with the number
set as an extra parameter.
| Input values | Extra parameter | Examples of masked values |
|---|---|---|
| 21 A48 |
"0" | 0 1 |