Create, Add, delete values in a Data Table

Objective

The objective of this How-To guide is to assist the users in creating a data table along with adding and removing values from it in Openbots Studio. Most processes require utilization of data tables to input data and to attach that data to the process requirement document.

Walkthrough

The following are the steps involved in creating, adding, and removing data from data table in Openbots Studio. It is a procedure that involves click level operations from the DataTable command list.

Step 1: To create a new blank data table with the required columns, select the Create DataTable command from the list of commands under DataTable. The user will define the instance name of the data table along with specifying the columns.

Select Create DataTable Command
Enter the alias name of the new data table (Table1)
Enter the column names as per requirement (ID, Name, Age, State)
Click OK

Step 2: After creating the structure of the data table, add data into it. Use the Add Data row command to fill in the data table with appropriate data. Repeat this process 4-5 times (user choice) to fill in considerable amount of data. User can also load data from any other existing data table.

Select Add DataRow Command
Enter the Data table instance name (Table1)
Input values for different columns in the data table in the prescribed order. (ID, Name, Age, State)
Click OK

Step 3: Create a blank word document and append the above created data table into it and append a text message mentioning it. To learn about word document creation and functions, refer to Semi-Complex word guide to perform these tasks. Utilize create word, add document, append data table, append text commands to perform the task.

Step 4: To delete a row from the data table, Remove data row command is utilized to perform the action. The user may need to update the data table by either removing or adding data. Delete a row from the table and append the updated table to the word document again.

Select Remove DataRow Command
Enter the Table instance name (Table1)
Enter the tuple (row) information to delete. (ID -> 1003)
Select the overwrite option (And)
Click OK

Step 5: Append the data table back to the word document and export the word file as a PDF and close the word application. Refer to Semi-Complex word guide for more information on word commands and functions. Use append data table, export to PDF, close word commands.

Resulting PDF File with both the data tables:

All the commands in this guide can be utilized alongside many of the other commands that will be discussed in later guides to perform several operations on Data Tables. Below is a snapshot of the process discussed in the guide.

Commands utilized for the above concept (Create, add, delete values in data table) are as follows:

Data Table Commands: Create Data Table, Add Data Row, Remove Data Row

Lets stay in touch!