Description

The PermutationQueryGen Generator automatically creates an SQL select statement from the specified parameters. It will query a column from a database table and dynamically load the results into a list. It will then communicate with other Attributes within the same Domain, also using a Permutation type Generator, to compute the sum of all possible permutations. It can generate all possible combinations of data for a given set of values queried from a set of columns within a database.

Parameters

The following parameters may be configured for the PermutationQueryGen Generator. Items with an asterisk* are required.

• resourceName* - Defines the name of the resource that contains the database connection information on a user's local machine.
• grvar1 - The first of five possible variables to use in the equation.
• grvar2 - The second of five possible variables to use in the equation.
• grvar3 - The third of five possible variables to use in the equation.
• grvar4 - The fourth of five possible variables to use in the equation.
• grvar5 - The fifth of five possible variables to use in the equation
• query* - Defines the SQL select statement to run.
• list - Stored one value on each line of the list. The listed value shown is only for simulation mode. When running a true Scenario, the data will be loaded from the specified database resource.

Training Video

This training video demonstrates this Generator’s ability to pull data from within a database and combine the data to generate permutations and populate another table.