Menu

Create, Edit, and Delete Datasets

Datasets

Click the Datasets tab to view all Datasets. From here, you can search the datasets by the dataset name. The number on top of the grid indicates how many datasets are active/inactive.

Filtering and Sorting Datasets

Filter by Dataset Status (Active/Inactive)

  • Click the number to filter the grid accordingly.  The line under the number lets you know in which dataset status the current grid is about. 
  • When you deselect the number, the grid will clear out the filter and display all datasets as default. 

 

Clear Filter

When the grid is filtered or searched, the Clear Filter button is displayed.  Click on it to clear all filters and revert to the default grid view (view all).

Sort by Most recent/ A-Z/ Z-A

Click Sort and select an option to sort the grid, as follows.

  • Most recent update: Most recent updated parameters will move up to the top of the grid.
  • A-Z: Sorts the grid alphabetically in ascending order.
  • Z-A: Sorts the grid alphabetically in descending order.

Create a Dataset

To create a new dataset, click the Create button from the Datasets Grid page.

1. Input basic information about the Dataset

  • Name (required), Description, Status Active / Inactive (click the circle to change the status: green for active and orange for inactive)

2. Generate Dataset

  • Select parameter as Dataset's column: Parameters which are active and have at least one value are displayed in the dropdown for you to select.  You can only see parameters belonging to qTest Manager projects you can access.
  • Click the blue plus icon  to create a new column.
  • Click the green plus icon  to create a new row or specify a number and click that icon  to create multiple rows.

NOTE: A Dataset can have a maximum of 25 columns.  It can contain a maximum of 1 million rows, but you are only able to add 25 rows per time.

3. Clear data & Reset Dataset

  • Clear values: All values/data of the Dataset will be cleared out, but its structure (selected columns) will be unchanged.
  • Reset Table: The dataset's structure and data are removed.  The Dataset reverts to its initial state where you can rebuild it from scratch.

 

Manually Input Data

  • When you click on a cell, a drop-down is displayed that shows all values of the parameter.  Those values are alphabetically sorted and the first ten are displayed by default.  If your parameter has more than 10 values, type into the cell to display more values in the dropdown and select.
  • Click x icon in the beginning of each row to remove it.

HINT: When selecting data for each data row, press Tab to move to the next cell, press the Up or Down Arrow to select a value from the drop-down.

Automatically Generate Data

There are two ways to automatically generate data in qTest Manager. 

  • Unique Values: Parameter values will not be repeated and no two rows will have the same parameter value.
  • Unique Combinations: Each row in the data grid will contain a unique combination.  Parameter values can be repeated; however, no two rows will have the same combination of data.

NOTE: The number in the green circle beside each method is the maximum possible rows that can be generated using that method.  For example, in the screenshot shown here, the maximum combinations is 162.                                                                                                                        

  • If you type 200 into the text box and click the Generate Data button, 162 rows will be generated.

When the number of possible combinations is very large, the system displays "k" for thousands, "m" for millions, and "b" for billions.  

For example: the following screenshots show the maximum number of possible combinations is 9000                

Edit / Delete Dataset

1. From the Dataset Grid Page, click a Dataset name to open its profile page.

2. Dataset's Data Grid

From here, you can update the Dataset's structure and data rows manually. 

  • Click the blue plus icon  to create a new column.
  • Click the green plus icon  to create a new row or specify a number and click that icon  to create multiple rows.
  • Update values by clicking on the cell and selecting values from the dropdown list.

3. Automatically generate data

From here you can select methods to regenerate data for your Dataset and specify the number of rows you want to generate.  When you confirm, all current data is replaced with newly generated data.

4. Save/ Delete/ Back

Click the Delete button to delete the Dataset.

Click the Save button to save all changes and redisplay the Datasets Grid page.

Click Back to go back to the Datasets Grid.  A reminder is displayed if you select Back without saving changes.

Subscribe To Our Blog
Powered by Zendesk