Editing datapools

After you data-drive a test to create a datapool or create an empty datapool, you can edit the records and variables in the datapool.

A datapool is a test dataset, a collection of related data records which supplies data values to the variables in a test script during test script playback. A record is a row in a datapool. A variable is a column in a datapool.

You can make the following changes to a datapool:

• Add, remove, move, or edit a record

• Add, remove, move, or edit a variable

• Edit datapool values

• Cut, copy, or paste a cell, a record, or a variable

Related concepts

Work with datapools

Related reference

Import Datapool dialog box

Selecting a record

About this task

To select a record:

• Click the column number, for example, 0, 1, or 2.

Add a record

About this task

To add a record:

Procedure

1. Click anywhere in the datapool editor or select a record, right-click, and then click Add Record.

   The new record appears after the selected record unless you select the first row.

2. If you select the first row, click Add Before or Add After to place the new record before or after the first record, and then click OK.

Removing a record

About this task

To remove a record:

• Select a record you want to delete, right-click the selected record, and then click Remove Record.

Moving a record

About this task

To move a record before or after another record:

Procedure

1. Select a record, and then right-click Edit Record.

2. Click the Index arrow to select the location where you want to move the record.

   For example, select Before 0 to move a record before record 0 or select After 12 to move a record after record 12.

3. Click OK.

Editing datapool values

About this task

To edit datapool values:

• Select the cell you want to change, double-click the selected cell, and then type the new value of the cell.

Add variables

About this task

To add a variable:

Procedure

1. Select a cell or click anywhere in the datapool editor, and then right-click Add Variable.

2. In the Add Variable dialog box, type the name of the new variable.

3. Type the full class name for the variable.

   The system String class is the default.

4. Click the Add arrow to select the location where you want to place the new variable.

   For example, select Before NameofVariable to place the new variable to the before an existing variable or select After NameofVariable to place the new variable after an existing variable.

5. Click OK.

Removing variables

About this task

To remove a variable:

• Right-click a cell in the variable you want to remove, and then click Remove Variable.

Change names, types, or move variables

About this task

To change the name, type, or to move a variable:

Procedure

1. Select a cell in the variable that you want to change.
   

2. Right-click, and then click Edit Variable.

3. In the Edit Variable dialog box, double-click or select the name of the variable and then type the new name of the variable.

4. Type the full class name for the variable. The system String class is the default.

5. Click the Move arrow to select the location where you want to move the variable.

   For example, select Before NameofVariable to move the variable before an existing variable or select After NameofVariable to move the variable after an existing variable in the datapool.

6. Click OK.

Cutting, copying or pasting cells, records, or variables

About this task

To cut, copy, or paste a cell, a record, or a variable:

• To delete data in a cell, record, or variable to the clipboard and copy it to the clipboard, select a cell, a record, or a variable, right-click, and then click Cut.

• To paste the contents of the clipboard, select a cell, record, or variable that you want to overwrite with the contents of the clipboard, right-click, and then click Paste.

• To copy a cell, record, or variable to the clipboard, select a cell, a record, or a variable, right-click, and then click Copy.