Data Generator provides the following types of weighted list generators:
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.
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.