Add column action in the Record package

Use the Add column action to add a new column to an existing record variable at a specific index position, and store the output within a destination record variable. You can then insert this destination record variable into a Data table or Dictionary object.

Settings

  • In the Actions palette, double-click or drag the Add 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.

  • (Optional) Enter a name for the column you want to add in the Column name field.
    Note: The column name is case sensitive. An error message is displayed if you try to add an existing column name. However, you can add a duplicate entry of an empty column name.
  • Click the Column type drop-down and select one of the following options as the type for the column that you are adding:
    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.
  • Use the Insert column at field to select one of the following options to specify the index:
    • first index: to insert the column at the first position (0 index) in a record variable.
    • last index: to insert the column at the last position of the record variable.
    • specific index: to insert a column at a specific position in the record variable.

      For example, to insert a column at index position 1, enter 0. The index number starts from 0. The first item in the record variable is at position 0, the second item at 1, and so on.

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