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

Automation 360

Add column action in the Record package