Using a Parameter spreadsheet to specify new Parameters and run a new Generation
August 26, 2020
|By Roberta Catizone
Created On
byRoberta Catizone
< Back
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.
Table of Contents