Searching and filtering in a Data Table

Objective

The objective of this How-To guide is to assist the users in searching and filtering data tables in Openbots Studio. Most processes require utilization of data table to input data into it and attach it to the process requirement document.

Walkthrough

The following are the steps involved in searching and filtering data tables in Openbots Studio. It is a procedure that involves click level operations from the data table command list.

Step 1: To create a new blank data table with required columns, select the create data table command from the list of commands under Data Table. 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 before appending the table. 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 search a row or row value in the data table, first extract or get the required data row into a variable using get data row command to index it while searching for a value in the specific row. The command is like Get cell command from the excel commands list.

Select Get DataRow Command
Enter the Table instance name (Table1)
Enter the data row index to extract (4, 5th row)
Enter the output variable name (Row4)
Click OK

Step 5: After extracting the row into a variable, search and extract the specific row value using the get data row value command. The row is indexed in the command using the variable and value is searched, extracted, and stored in a variable to be used.

Select Get DataRow Value Command
Enter the row index variable (Row4)
Select the search option to update the value (Column Name)
Enter the Column value to be searched and extracted (Name)
Enter the variable name to store the searched data (Roww)
Click OK

Step 6: Append the searched value to the word document with text stating “Searched Name in Row 5”. Refer to Semi-Complex word guide for more information on word commands and functions. Use append text. The command will attach the data item (Name) to the word file in a new line (Paragraph change).

Step 7: To extract the total number of rows in the data table, use the Get data row count command. The count command will count the number of rows in the data table and store it in a variable which can be used in elsewhere.

Select Get DataRow Count Command
Enter the Data table instance (Table1)
Enter the output variable name (CountTable)
Click OK

Step 8: Append the row count value to the word document with text stating “Total Row Count”. Refer to Semi-Complex word guide for more information on word commands and functions. Use append text. The command will attach the data item (Row count) to the word file in a new line (Paragraph change).

Step 9: To Filter the data table, select the command filter data table from the list and input the criteria of filtering. The command filters the data table and provide only those rows which stands true for the condition. The data table is filtered based on the state Texas and the command will return all the data rows containing ‘TX’ in the state column.

Select Filter DataTable Command
Enter data table instance (Table1)
Enter Filtered data table instance (FilterTable)
Enter the Tuple Condition for filtering (State,TX)
Click OK

Step 10: Append the filtered data table to the word document with text stating “Filtered Table” and export the word document as PDF and close it. Refer to Semi-Complex word guide for more information on word commands and functions. Use append data table, append text, export to PDF, close word. The new updated data table will be attached to the word file before saving it and converting to PDF. The word application is then closed.

Resulting PDF File with the data tables and other information:

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 (Searching and Filtering data tables) are as follows:

Data Table Commands: Create Data Table, Add Data Row, Get DataRow, Get DataRow value, Get DataRow Count, Filter DataTable

Lets stay in touch!