Insert column action

The Insert column action in the Data Table package enables you to insert a column from one table to another table or insert a custom column of a specified data type to the destination table.

Settings

  • In the Destination table field, select the destination data table in which you want to enter the data.
  • Select where you want to insert the column: first index, last index, or specific index.
    Note: If you selected specific index, then enter the index number where you want to insert the column.

    Destination table

  • From the Insert column option, select one of the following options:
    • From source table: Select to enter data from another table to the destination table.
    • Custom column: Select to insert an empty column or a column with specified data to the destination table.
      Note: You can add only one custom column at a time.
  • If you selected the From source table option, then perform the following steps:
    • In the Enter data from field, select a source table from which you want to enter data.Insert column from the source table
    • Enter the name or index number of the column that you want to insert from the source table.
      Note: The index count starts at 0.
  • If you have selected the Custom column option, then perform the following steps:
    • In the Column name field, specify the name of the column that you want to insert.Add custom column to the data table
    • In the Column type field, specify the data type of the column that you want to insert.
      Note:
      • String, Number, Boolean, and Datetime data types are supported.
      • In the Column type field, if you select Datetime as the datatype, the default value will be empty. If you run the bot with an empty value in the Datetime variable field, the action uses the current system date and time by default and then inserts that date and time in the Data Table.
    • In the Default value field, specify the value that you want to display in each row of the new column.

    See Example of using Custom column option in Data Table package on how to use the Insert column action.