# 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.