Reference › Test Case Reference › Data Set Descriptions › Create Your Own Data Sheet Data Set

Create Your Own Data Sheet Data Set

The Data Sheet data set lets you generate your data set data in DevTest, without requiring any reference to an external file.

The Data Sheet consists of a data table. The column headings specify the property names and the table rows specify the data values for those properties. The table skeleton is built by specifying the number of rows and the column names (properties). The default name is Create your own Data Sheet. Subsequent data sheets that are created have "~number" appended to the data sheet name.

Complete the following fields:

Name

Enter the name of the data set.

Local

Designates whether the data set is global or local. Global is the default. Local data sets are created with one for each simulator. Global data sets are created once and shared by all simulators.

Random

Whether the record after the current record (sequential access) is read, or a random record is read. Sequential reading is the default.

Max Records to Fetch

The upper bound on the number of records to fetch for random access. This text field is disabled if the Random check box is not selected.

At End Of Data

Select the action for the end of the data set. You can start over, reading values from the start of the data set, or you can select the step to execute.

Number of Rows

The initial estimate of the number of rows. This value can be modified later.

Column Names

Comma delimited list of column names. These names are also the property names.

Click the Create Data Sheet Skeleton button and enter your data into the table.

To sort ascending or descending on a column, click the column labels. Right-click the column label for a column menu.

Encrypt Column

To encrypt all values in the column, select this option. An encrypted column has a lock icon and all values appear as a row of asterisks. Exporting shows that the column is <name>_enc and the data is encrypted.

Change column name:

To rename the column, select this option.

Sort Ascending

To sort the column values ascending, select this option. To change the sort to descending, click again.

Reset Sort

To sort the column values as they were originally, select this option.

Column Resize Mode:

Select Automatic, Subsequent, Next, Last, or Manual.

Maximize All Columns

Selecting this option changes the Column Resize Mode to Manual. The columns are all displayed, and scroll bars are available.

To create and modify the table, use the functions in the bottom toolbar.

Add

Add rows to the table.

Up and Down

Select a row and move it up or down in the table.

Delete

Delete the selected row.

Add Column

Add a column to your table.

Delete Column

Delete a column. Select a cell in the column you want deleted, making sure that the cell is selected for editing, and click this button.

Click the Test and Keep button to test and load the data. You get a message that confirms that the data set can be read, and shows the first set of data.

You can also complete the following actions:

• To sort the rows, double-click the column header.
• To change the column name, right-click on the column name
• To select the toolbar functions and Launch Extended View to edit the cell, select and then right-click a cell.
• To convert your data sheet to a data set or a file, click Convert to Data Set at the bottom of the panel.

  

Data Sheet to Convert

By default, the data sheet you created, or select from the pull-down list.

External File Name

The name and path of the file you want to create from the data sheet.

Note: Moving the rows up or down in the table can affect the outcome of a test. The order of columns does not affect the outcome of the test.

Select the steps that use the data sheet.