Editing datasets

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

A dataset 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 dataset. A variable is a column in a dataset.

You can make the following changes to a dataset:

Add, remove, move, or edit a row
Add, remove, move, or edit a column
Edit or clear cell(s)
Cut, copy, or paste a cell, row, or column

Note: To have seamless access to a dataset CSV editor, you can use any one of the following web browsers on Windows, Linux or Mac operating systems:

Mozilla Firefox
Google Chrome
Microsoft Edge based on Chromium

Selecting a record

To select a record, you must click the column number. For example, 0, 1, or 2.

Adding a record

Click anywhere in the dataset 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.
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

Select a record that you want to delete.
Click Remove Record.

Moving a record

To move a record before or after another record:

Select a record, and then right-click Edit Record.
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.
Click OK.

Editing dataset values

Select the cell you want to change.
Double-click the selected cell and type the new value of the cell.

Adding variables

Select a cell or click anywhere in the dataset editor, and then right-click Add Variable.
In the Add Variable dialog, type the name of the new variable.
Type the full class name for the variable.
The system String class is the default.
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.
Click OK.

Removing variables

Right-click a cell in the variable you want to remove.
Click Remove Variable.

Changing names, types, or move variables

Select a cell in the variable that you want to change.
Right-click, and then click Edit Variable.
In the Edit Variable dialog, double-click or select the name of the variable and then type the new name of the variable.
Type the full class name for the variable.
The system String class is the default.
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 dataset.
Click OK.

Cutting, copying or pasting cells, records, or variables

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.

Updating dataset values programmatically

You can also update the dataset values by using the getValue and setValue APIs.

Use the following code sample to update the dataset in a test script from the required CSV file.

public void testMain(Object[] args)
    {    
        String cursorId= "differentTestCursor";
        Cursor cursorOptions = Cursor.builder()
                .cursorId(cursorId)
                 .accessMode(AccessModeEnum.OVERWRITE)
                 .fetchMode(FetchModeEnum.SEQUENTIAL)
                 .shareMode(ShareModeEnum.SHARED)                 
                 .lastActive(null)
                 .wrap(true)
                 .build();
        
        //provide name of the dataset file as argument
        Path path= Paths.get("setCellGetCell.csv");
        String DatasetPath=path.toAbsolutePath().toString();
        String DatasetEncodedPath = Base64.getEncoder().encodeToString(DatasetPath.getBytes());
               
        DatasetCursor createdCursor= CursorFactory.getWorkbenchDatasetCursor("localhost", 7081,
                DatasetEncodedPath, cursorOptions);          
            
        DatasetRow row= createdCursor.nextRow();
        String ExistigValue=row.getValue("Column1");
        
        System.out.println(ExistigValue);
        logInfo(ExistigValue);
        
        row.setValue("Column1", "Test");
        String Newvalue=row.getValue("Column1");
        System.out.println(Newvalue);
        logInfo(Newvalue);
        
        createdCursor.deleteCursor(true);
        }
}