Create DataTables

A DataTable is a file that stores test data in rows and columns. Each row represents one test iteration, allowing you to run the same flow with different data sets.

You can use DataTables to:

For example: If you create two DataTables for a login flow, one for Admin users and one for users with fewer permissions, you can run different tests using the relevant DataTables. You can add one or more DataTables to a test flow. You could also have multiple rows for distinct users, each with different permissions, without splitting them into separate DataTables.

You can create a DataTable directly in Scriptless Mobile or upload an external DataTable file, in CSV format. External files must follow the required structure (title row, data type row, and data rows). For example, you can create a CSV file in Excel and upload it. To learn more, see DataTable structure.

DataTable structure

When you upload a DataTable created outside Scriptless Mobile, the file must abide to the following structure:

  • Title row (Row 1): Column names

  • Data type row (Row 2): Data type for each column

    Allowed date types:

    • Device: Device ID

    • String: Text

    • Media: Path to repository file

    • Boolean: True or false

    • Number: Whole number (integer)

    • Secured String: Encrypted text

  • Data rows (Row 3+): Test data values matching the specified data type

Scriptless Mobile uses this structure to validate and map your data correctly. If the structure does not meet these requirements, the DataTable import may result in unexpected behavior.

The following image illustrates this structure.

The following image shows a sample CSV file.

A sample CSV file that you can upload in Scriptless Mobile is available here: SampleDT.csv

If you create a DataTable directly in Scriptless Mobile, you don’t need to worry about this structure.

Create a CSV file in Excel

A simple way to create a CSV file is by using Microsoft Excel:

  1. In the first row, enter the column names.

  2. In the second row, specify the data type for each column.

  3. In all subsequent rows, enter your data.

  4. When done, save the file in CSV format.

Limitation

In Scriptless Mobile, a DataTable column with the URL data type is converted to the String data type. If you edit this column and save the DataTable, the column remains as String in Scriptless Mobile and other applications.

Overview video

Watch the following short video for an overview of working with DataTables, or refer to the steps following the video.

Steps

Click a procedure to expand its steps.

  1. On the top toolbar, click the DataTable button and select Create new DataTable.

  2. In the Create new DataTable view, enter the column name and select the desired data type for the column.

  3. To add a row, click Add row and enter data according to the selected data type.

    You can add as many data rows as required.

  4. To add a column, click Add column.

    Name the column, select the data type, and enter data according to the selected data type.

    You can add as many columns as required.

    • For a column with Device data type, you can select multiple devices and add them to your DataTable in one go. The devices appear as one device per data row.

    • To manually encrypt the data in a Secured String column, click the encryption button . If any cells in the column remain unencrypted when you upload the DataTable, Scriptless Mobile encrypts them during the upload process.

      Changing the type of an existing column from String to Secured String automatically encrypts any existing cell content.

      To copy encrypted data, click the copy button . To delete the data, click the clear value button .

  5. Click SAVE AS.

    1. In the Save as DataTable dialog box, enter a name for the DataTable.

    2. Select the destination. You can also create a new folder for the DataTable.

      The available default folders are Public DataTables and My DataTables. If you belong to an org group, you can also see the org group folder.

    3. Click SAVE.

Making changes to a DataTable will overwrite the previously saved version.

  1. On the top toolbar, click the DataTable button and select Open DataTable.

  2. In the Open DataTable view, in the left pane, search for the DataTable, or expand the folders and select the required DataTable.

    The selected DataTable appears in the right pane.

    When a device or media item in the selected DataTable is unavailable, a warning icon appears.

  3. To open it in edit mode, click EDIT.

  4. Make the required changes.

  5. To save your changes, click SAVE or SAVE AS:

    • If you clicked SAVE, click YES to overwrite the existing DataTable version. In the Save as DataTable dialog box, click SAVE.

    • If you clicked SAVE AS, do the following:

      1. In the Save as DataTable dialog box, enter a name for the DataTable.

      2. Select or create a destination folder.

      3. Click SAVE.

  1. On the top toolbar, click the DataTable button and select Upload DataTable.

  2. In the Upload DataTable view, to upload a file from your local machine, click upload a file.

  3. In the dialog box that opens, navigate to and select your file, and then click Open.

    If the file and its content get approved, the data in the CSV file appears in the right pane.

    A warning icon appears if:

    • A device or media becomes unavailable

    • A column name is missing

    • The data type of a column is invalid

  4. (Optional) Click EDIT to make changes to the uploaded file.

  5. Click FINISH.

What's next?

The command parameter of a test can use a DataTable as its value. To learn more, see Use a DataTable as a parameter value.