Generate Rows Tool
Use Generate Rows to create new rows of data with an expression. Use this tool to create a sequence of numbers, transactions, or dates.
Tip
This tool has a One Tool Example. Visit Access Sample Workflows to learn how to access this and many other examples directly in Designer Cloud.
The Generate Rows tool follows a process to generate rows of data. That process consists of an initial expression (applied to row 1), then a loop expression is applied (such as an increment) that builds subsequent rows, based on a condition (true or false) that ultimately build rows until the condition is false when it terminates the loop.
Connect an Input
An input connection to this tool is optional.
Configure the Tool
Choose to create a new column or update an existing column.
Create New Column: The tool is configured as an input. If you choose this method, specify the New Column Name and the appropriate Type.
Update Existing Column: Assesses the rows coming in and adds new rows accordingly. One example is an input that contains a start and an end value where you would like to generate a row for each value in between. Select the Column Name from the dropdown. You must have an input connected to the tool for this option.
Create an expression to generate rows.
Initial Value: Specify the initial value using an expression. The first generated row is populated with the initial value.
While Condition: Specify a while condition for row generation. Rows are generated when the while condition is true. When the while condition is false, row generation stops.
Output Value Expression: Specify an expression to compute the output. This is typically an increment that generates rows until the while condition is false.
Troubleshooting
GenerateRows (5): The value did not change after the Loop Expression.Adjust your Loop Expression to contain the column being modified.