Weighted List Generators

Data Generator provides the following types of weighted list generators:

  • Weighted List Generator (simple) - generates flat values according to a specified ratio.
  • Weighted List Generator (nested) - generates values from nested value lists according to a specified ratio.
  • Weighted List Generator (ranged) - generates values in a specified range.
  • Weighted List Generator (regexp) - generates regexp data according to a specified ratio. The dialog box for each type of the Weighted List Generators contains Basic Settings, custom settings, and a data grid. You can customize the generator by changing the basic and custom settings.

Custom Settings

Buttons

Load values from File

Opens a dialog box to select a file and retrieve data from the file into the data grid.

Load values from Table or Veiw

Opens a dialog box to select the connection, database, table or view, and column to retrieve data from. In the WHERE filter box, type or paste a statement to filter the data being retrieved and click Validate.

Load Values from SQL Query

Opens a dialog box to select the connection, database, and column to retrieve data from. In the SQL Query box, type or paste a statement to filter the data being retrieved. Choose the column with the correct data type.

Save Values to File

Specify the directory to save the file.

Add a Value

Adds a new empty line in the Value field and a default weight value 10.

Delete Current Value

Deletes a line and navigates a focus to a subsequent line.

Clear values list

Clears all values from the data grid.

Data Grid

A data grid represents a table of data to be populated. The data grid of each weighted list generator includes the following columns: Order Number, Value, Weight, and Percentage (%). The Value column contains generated values. The Weight column contains weight ratios of the values. The Percentage (%) column shows the percentage of occurrences of each value in the column with respect to the rest of the values.

Weighted List Generator (nested)

The nested Weighted List Generator contains two data grids: a main data grid and a nested data grid. The main data grid is non-editable except for the Weight column. Upon clicking the Value column of the main data grid, the nested data grid appears. In the nested data grid, columns Value and Weight are editable. The Percentage (%) column is a calculated column.

At the bottom of the nested data grid, buttons Load values from File, Save values to File, Add a Value, Delete current value, Clear values list are placed. The buttons function similar to those described above.

Weighted List Generator (ranged)

The data grid in the ranged Weighted List Generator contains five columns: Order Number, From, To, Weight, and Percentage (%). The From column includes initial values of a value range and the To column includes end values of the value range. For date values, on clicking the From and To columns, a calendar window appears.