Set value of a single cell action

Use the Set value of a single cell action to update the value of a specific cell.

Settings

  • Click the Data table name drop-down menu and select the variable that you have used to store the name of an existing data table.

    If a variable is not available, click the Create variable icon to create and select it

  • In the Row by index, enter the row index.

    For example, to set a value to the first row in the selected data table, enter 0. If you have stored this value as a variable, you can click the Insert a value icon.

  • Use the Column by field to select one of the following options:
    • Name - To specify the name of the column and sort the values within it.

      (Optional) Click the Insert a value icon to select an existing variable that contains the column name.

    • Index - To specify the column index.

      (Optional) Click the Insert a value icon to select an existing variable that contains the table index.

      Index numbers start from 0. For example, if you have a data table that contains four columns and you want sort the values in the third column, enter 2 in the index field.

    Note: You can only sort the values within one column at a time. In order to sort the values across multiple columns of a data table, you must use the Sort action multiple times.
  • (Optional) In the Set value of table cell field, enter a value that you want to set.

    Click the Insert a value icon to select an existing variable that contains this value.

    Note: Only string variable type is supported in the input field. While creating a string variable, you can enter a Number or DatetTme values in the respective columns. However, while inserting into a number/datetime column it will be inserted as a number or date.