Write to Data Table

This is a pre-built Action located under the @Generic Element. The functionality of this Action in Avo Assure is to write data back to the data table based on the provided data table path. The execution result is stored in the dynamic variable.

Syntax

Input Value: <datatable_path>;<row>;<col>;<value>

Note:

• Create and copy the data table path from the Test Data management page. To learn how to create Data Table, click here.

• When pasting the data table path from the Test Data Management page, the path appears in this format: avoassure/folder name/table name. You must remove the avoassure/ prefix from the path before using it.

Argument	Description
<datatable_path> (Required)	Provide the path of the data table where you want to write the data.
<row> (Required)	Provide the row number where you want to write the value.
<col> (Required)	Provide the column number where you want to write the value.
<value> (Required)	Provide the value you want to enter in the specified row and column.

Output Value: <Dynamic Variable>(Optional);<Dynamic Variable>(Optional)

Argument	Description
<Dynamic Variable>(Optional);<Dynamic Variable>(Optional)	Both dynamic variables store the status as True or False.

Example: Writing a Value into a Data Table

In this example, we explain how to write a specific value into a selected row and column of a data table.

• Action: Write to Data Table

• Input Value: Login Details/User Info;1;1;John

  • The first argument (Login Details/User Info) specifies the target data table name (User Info).

  • The second argument (1) specifies the row number where the value must be written.

  • The third argument (1) specifies the column number where the value must be updated.

  • The fourth argument (John) specifies the value to be written into the selected row and column.

• Output Value: {WriteStatus}

  • The result of the write operation is stored in the {WriteStatus} dynamic variable, with the following possible values:

    • True: If the value is successfully written to the specified row and column.

    • False: If the operation fails due to an invalid table name, incorrect row/column reference, or unreadable data table.

• Logical Explanation: The Write to Data Table action takes the value from the Input Value column (Login Details/User Info;1;1;John). It writes the value John into row 1 and column 1 of the User Info data table. After the update, the execution result is stored in the {WriteStatus} variable.