Generate Rows Tool
The Generate Rows tool creates new rows of data at the record level. Use this tool to create a sequence of numbers, transactions, or dates.
The Generate Rows tool follows a process to generate rows of data. That process consists of an initial expression (applied to record 1), then a loop expression is applied (such as an increment) that will build subsequent rows, based on a condition (true or false) that will ultimately build rows until the condition is false, when it will terminate the loop.
Connect an input
An input connection to this tool is optional.
Configure the tool
- Choose to update an existing field or create a new field.
- Update Existing Fields: Assesses the rows coming in and adds new records accordingly. One example would be if your input contains a start and an end value and you would like to generate a row for each value in between.
- Create New Field: The tool will be configured as an input. If this method is chosen, specify the new Field Name and appropriate Type and Size.
LOWRANGE <= [HIRANGE]
LOWRANGE + 1
Configure the Condition Expression so row generation ends to preserve hard drive space.
● GenerateRows (5): The value did not change after the Loop Expression.
Adjust your Loop Expression to contain the Field being modified.
Because this tool includes an expression editor, an additional input anchor displays when the tool is used in an app or macro workflow. Use the Interface tools to connect to a Question anchor. See Interface Tools.