Using a Parameter spreadsheet to specify new Parameters and run a new Generation
Create a new spreadsheet containing the new parameters and values. Here is an example:
Generate Data by running the VIP Flow without the added/changed Data.
Look at the results (without changes) in the Database Manager such as SQL Manager.
Change/add any parameters you would like in the Configuration spreadsheet.
Specify the Parameter sheet name in the VIP Flow
Execute the VIP Flow with the new added Parameters.
This process allows the user to:
Control how many rows they want to generate based on the Parameters file
Control Arguments to pass using the Parameters sheet
Parameters can be exposed and a form can be created in the VIP Modeller which can invoke the underlying Flow to Generate the Data.
Example: If we had to create Random Order Items for each Order then we can override our parItem_OrderItem_variable and get a Random integer between 1 and 10 and tell it to re-evaluate itself after each Order is generated, so that when an Order is generated it will re-evaluate that value and use a random value for OrderItem.