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.

About this task

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

Procedure

  1. 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.

  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

Procedure

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

Moving a record

Procedure

To move a record before or after another record:
  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 dataset values

Procedure

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

Adding variables

Procedure

  1. Select a cell or click anywhere in the dataset editor, and then right-click Add Variable.
  2. In the Add Variable dialog, 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

Procedure

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

Changing names, types, or move variables

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, 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 dataset.

  6. 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.

Procedure

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);
        }
}