Use of Data Table in UiPath

Use of Data Table in UiPath

Data is a very integral part of any process and it isn’t any different for UiPath automation. In most data driven processes, we are either reading data or modifying it. Data Table is the type of variable that can store data as a simple spreadsheet with rows and columns. You can identify each piece of data based on its unique column and row coordinates.

In Data Tables, the regular convention of identifying the columns and the rows are applied. Columns are identified through capital letters and rows through numbers.

A Data Table is an in-memory representation of a single database table which has a collection of rows and columns.

How are Data Tables Created?

The most common activities and method to create Data Tables are:

  1. The Build Data Table Activity
  2. The Read Range Activity
  3. The Read CSV Activity
  4. The Data Scraping Action
  5. The Generate Data Table from Text Activity
  1. Build Data Table Activity: – By using this activity, you choose the number of columns and the data type of each of them. Moreover, you can configure each column with specific options like allow null values, unique values, auto-increment (for numbers), default value and length (for Strings).

a. Drag and Drop Build Data Table Activity from the activity panel.

Drag and Drop Build Data Table Activity from the activity panel.

b. Click on Data Table and Configure column as per requirements.

Click on Data Table and Configure column as per requirements.

c. Column properties configuration

Column properties configuration

2. Read CSV Activity: – This activity captures the content of a csv file and stores it in a Data Table variable. Although not commonly used anymore, there are still legacy or internal-built applications with this kind of documents. This activity resides under the app integration section under CSV option.

Read CSV Activity

You can directly drag and drop the activity into the workflow and start using it.

directly drag and drop the activity into the workflow and start using it

3. Read Range Activity: – This is the most common activity to create data table which is being used when you are working on the excel files. This activity gets the content of worksheet (or a selection from that worksheet) and stores it in a data table variable, which can be created from the properties panel using Ctrl + K.

Read range activity

There are two types of Read Range activities available in Activity panel. One under the Excel Activity and the other is under the Workbook Activity. There is no hard difference between both the activities. Both populate the data table as an output. For Excel activity Read Range you need to use Excel Application scope whereas for workbook activity you can directly use the Read Range.

Excel Activity

Excel activity

Workbook Activity

Workbook activity

4. Data Scraping Action: – This functionality of UiPath studio enables you to extract structured data from your browser, application, or document to a Data Table.


5. Generate Data Table from Text Activity: – This can be used to create a Data Table from structured text, by letting the use indicate the row and column separators. You can use this activity by drag and drop from activity panel.

Generate data table

UiPath offers a broad range of activities that can be used to work with Datable Variable: –

  1. Add Data Column: – Adds a column to an existing Data Table variable. The input data can be of Data Column type or the column can be added empty by specifying the data type and configuring the options (allowing null values, requesting unique values, auto-incrementing, default value and maximum length).
  2. Add Data Row: – Adds a new row to an existing Data Table variable. The input data can be of Data Row type or can be entered as an Array Row, by matching each object with the data type of each column.
  3. Build Data Table: – Is used to create a Data Table using a dedicated window. This activity allows the customization of number of columns and type of data for each column.
  4. Clear Data Table: – Clears all the data in an existing Data Table variable.
  5. Filter Data Table: – Allows filtering a Data Table through a Filter Wizard using various conditions. This activity can be configured to create a new Data Table for the output of the activity or to keep the existing one and filter (delete) the entries that do not match the filtering conditions.
  6. For Each Row in Data Table: – Is used to perform a certain activity for each row of Data Table (like For Each Loop).
  7. Generate Data Table from Text: – Can be used to create a Data Table from structured text by letting the user indicate the row and column separators.
  8. Join Data Tables: – Combines rows from row tables by using values common to each other using the Join Wizard, according to a join rule that answers the question “What to do with the data that doesn’t match?”. It is one of the most useful activities in business scenarios, where working with more than one Data Table is very common.
  9. Lookup Data Table: – It is like VLOOKUP in Excel. You can search for a provided value in the specified Data Table and the Row Index returns its value. It can also be configured to return the value from a cell with the given coordinates (Row Index and Target Column).
  10. Merge Data Table: – Is used to append a specified Data Table to the current Data Table. The operation is simpler than Join Data Type activity, as it has 4 predefined actions to perform over the missing schema.
  11. Output Data Table: – Writes a Data Table to a string using the CSV format.
  12. Remove Data Column:  – Removes a certain column from a specified Data Table. The input may consist of the column index, column name or Data Column variable.
  13. Remove Data Row: – Removes a row from a specified Data Table. The input may consist of the row index or a Data Row variable.
  14. Remove Duplicate Row: – Removes the duplicate rows from a specified Data Table variable, keeping only the first occurrence.
  15. Sort Data Table: – Can sort a Data Table in an ascending or descending order of the values in a specific column.
  16. Get Row Item: – Retrieves a value from a row in a Data Table according to a specified column.
  17. Update Row Item: – Assigns a specified value to the indicated column of a Data Table row.

Leave a Reply

Retype the CAPTCHA code from the image
Change the CAPTCHA codeSpeak the CAPTCHA code
 

SOAIS - Worksoft Newsletter

To view on your browser, click here
Facebook Twitter LinkedIn
Dear Default Value,
 

Welcome to SOAIS Newsletter of September 2021!

Continuous Testing with Remote Execution
 
The speed of innovation continues to increase, driving rapid and relentless change for today’s ever-evolving IT landscapes, creating greater risk as IT and business teams scramble to ensure timely delivery. How can your organization keep pace? Test more, worry less. With Worksoft’s Connective Automation Platform, you can easily build and maintain automated tests, accelerating testing time without losing scope or volume. You can schedule and execute remote, continuous tests to intercept defects sooner and prioritize remediation - without sacrificing your nights and weekends. Explore how continuous test automation and remote execution can empower your organization.

Click here to connect with us to get more information on our services.
 

Skip Costly Rework with Dynamic Change Resiliency​

Change resiliency is imperative in ever-evolving IT environments. Our patented object action framework streamlines change management by assigning object definitions to your shared assets. The same object may be used in a thousand automation steps, but it can be easily updated by making one simple change to the model definition. The change automatically propagates to every single instance where that object may have been used without a single line of code or manual human involvement. For more change readiness you can also engage our Impact Analysis for SAP to predict how changes in SAP transports will affect your business processes. 

Please click here to watch the video to get a gist.
 

SOAIS Blog – Nuts and bolts of Certify Database Maintenance​

One of the key thing, which is often missed by the organizations, who have invested in using Worksoft Certify for automating their Business Process Validation initiatives, is implementing a Database Maintenance Plan. While the business and the test automation consultants get excited about the shiny new thing that they have got and start building the regression suite; planning and executing a database maintenance plan for most of the customers gets pushed down the priority list. However, since all the test assets in Certify are stored in a Database, a robust database maintenance plan is very important to maintain smooth operation of Certify with acceptable performance criteria. The customers usually start facing issues once they have built significant number of Certify processes which they have started executing on regular basis. Such executions add a lot of data to the tables storing results data and increase the overall size of the Certify database.

Please click here to read the complete blog.
 

Worksoft Blog – Process Intelligence: A Multi-Dimensional Approach

The ability to extract process knowledge has become easier through the years. Technology has evolved to the point where we can deploy capabilities that connect at multiple levels to extract different types of process insight. In the past, organizations were forced to spend enormous energy extracting data manually from different applications and databases. Then, they would have to use things like spreadsheets to transform the data and convert it into meaningful information. 

Please click here and read the complete blog.
 
India
Unit 9, Level 5, Navigator, ITPL,
Bangalore - 560 066.
Phone: +91 80 40071234
US
Suite 101, 1979, N Mill St,
Naperville, IL 60563
Phone 1-800-262-2427
Please click here to Unsubscribe / Unsubscribe Preferences

Leave us your info