Update column action in the Record package

Use the Update column action to update the value of a column within an existing record variable at the specified index or name, and store the output in the destination record variable.

Settings

  • In the Actions palette, double-click or drag the Update column action from the Record package.
  • Click the Source record variable drop-down and select an existing source record variable.

    If there are no existing record variables, create one.

  • Use the Update column by field to select one of the following options to update a column:
    • Column index: to specify the column number.

      Indexing starts from 0. Enter 5 to indicate the sixth column from the left.

    • Column name: to specify the name of a column.
      Note: The column name is case sensitive. Ensure that you provide the correct column name. If there are duplicate column names, then the first matching column from the left will be updated.
  • Click the Column type drop-down and select one of the following options as the data type for the column that you are updating:
    Option Description
    String Enter a string value that you want to set to the new column. To insert a variable into the Value field, click the Insert a value icon and select a variable.
    Number Enter a numeric value that you want to set to the new column in the Value field.
    Boolean Click True or False tab to select a Boolean value, or click the Variable tab to insert an existing Boolean variable.
    Datetime
    Use the Datetime tab to select the following:
    • Select a date from the calendar.
    • Select the time.
    • Use the drop-down to select a time zone.
    The Datetime is empty by default. If you run the bot without changing the default value, the action will use the current date, time and time zone of the system.
  • Click the Destination record variable drop-down to select an existing destination record variable.

    (Optional) Click the Create variable icon to create a record variable. For more information, see Record variable.