Generate Rows
Description
Generate Rows is a step in the Input Plugin for Process Studio Workflows. Generate rows step is a data generating step that generates a single row or a specified number of rows. By default, the rows are empty; however, you may define a few static fields. Generate Rows is used primarily for testing purposes.
You may generate only one row that is an initiating point for your workflow. For example, you might generate one row that contains two or three field values that you might use to parameterize your workflow and then generate the real rows.
Or you may use Generate Rows to generate a specified number of rows. It may be useful for generating a fixed number of rows, for example, you want exactly 12 rows for 12 months of a year.
Configurations
| Field Name | Description |
|---|---|
| Variables Tab | |
| Step Name | Specify the name of the step. The name must be unique in a single workflow. |
| Limit | Limit sets the maximum number of rows to generate. |
| Never stop generating rows | Enable this checkbox for real-time use cases where you never want to stop the running workflow. The output of this step is then used to drive recurring tasks like polling from a file, queue, and database. |
| Interval in ms | Specify the interval between generated rows in milliseconds. |
| Current row time field name | Specify the optional field name for the Date field containing the time when the current row was generated. |
| Previous row time field name | Specify the optional field name for the Date field containing the time when the previous row was generated. |
| Fields: | This table is where you configure the structure and values of the rows you are generating (optional). Value for a field can be an environment variable too, e.g. ${paramater1} |
| Name | Specify the name of the column as it appears in the output rows. |
| Type | Select the data type for the field to ensure correct processing. Available data types: - Number - String - Date - Boolean - Integer - BigNumber - Binary - Timestamp - Internet Address |
| Format | Specify the format to parse the incoming data correctly. The format is used to read or display field value based on the selected type. For example, Select MM/dd/yyyy to read a date value like 12/25/2025 correctly. |
| Length | Specify the maximum allowable length for the field. For strings, this represents the character count; for numbers, it represents the total number of significant digits. For example, Set Length to 10 to allow a maximum of 10 characters, such as INV1234567. |
| Precision | Specify the number of decimal places allowed for numeric values. For example, Set Precision to 2 to store values like 123.45 |
| Currency | Specify the currency symbol used in the input data, such as ₹, $, or €. For example, enter ₹ to display amounts as ₹5000. |
| Decimal | Specify the character used as the decimal separator, for example, a dot( . ) or a comma (,). |
| Group | Specify the character used to separate thousands or other distinct groups within large numbers. For example, a dot (.) or a comma (,). |
| Value | Specify the data value of the field. The field accepts static or environment variable. |
| Secret | Select Y to mark the field as a secret. The step masks the value (displays ********) in subsequent steps, previews, and logs. To protect the data, the step excludes the field by default when writing to an output file or database. Select N to keep the field value visible as plain text. The step displays the actual value in previews and logs and writes it to the output file or database. Important: - If a secret field is combined with plain text in an earlier step (for example, using a Calculator step to create "Token: " + secretField), the result is treated as a new field and is not protected automatically. Mark the new field as Secret to protect its value. |