How to work with Data Table in Ui Path

How to work with Data Table in Ui Path

Data Table activities are one of the most important activities in Ui Path. Using Data Table activities you can maintain big pieces of data in Data Table Variables. Ui Path gives us a wide range of Data Table activities which can be used with Data Table variable.

Let’s consider a simple scenario where we will create a Data Table which have two columns “Country” and “City” and the Data Table have multiple rows of  data. Then we need to sort the Data Table in ascending order based on the “Country” column values. Last we will display the Output in a message box.

Step 1: Create a new Flow Chart then add a Build Data Table activity to the Flow Chart.

Build data table

Step 2: Double click on the Build Data Table activity. Then click on the Data Table button to create the Data Table.

Data table

Step 3: In the Build Data Table window we can add, modify and delete the column and rows by clicking on the highlighted buttons.

Column

Step 4: Now we need to edit the columns by clicking on Edit Column button. In the Edit Column window we can give column name, Select the data type of the column, Input the length and also we can allow null values by clicking on the Allow Null check box.

Edit column

Step 5: After editing the columns now we need to input the values which is needed for the scenario then we need to press Ok button.

Build data table_ok

Step 6: After adding all the values in Build Data Table window. Next in the Properties panel, in the Output Data Table field we need to add a Data Table variable for storing the output. Now the Build Data Table activity is completed.

Output data

Step 7: Now for sorting the data we need to add the Sort Data Table activity into the Flowchart after Build Data Table activity.

Sort data table

Step 8: After adding Sort Data Table activity we need to go to the Properties panel of Sort Data Table activity. In the Properties panel we need to add Input Data Table variable which should be same as Output variable of  Build Data Table activity , add Output Data Table variable (We can use same Data Table variable for Input and Output), input Name of the column which we want to sort and need to select the Order of sorting Ascending or Descending.

Activity coverage

Step 9: Next we need to add Output Data Table activity which will convert the Data Table to a string.

Output data table

Step 10: Now in Properties panel of Output Data Table activity we need to add Input Data Table variable and Output Text variable for storing the output as string.

Resources

Step 11: After Output Data Table activity we need add Message Box activity for display the output as a text message.

Message box

Step 12: Next in Properties panel of Message Box activity in Text section we need to add the variable. The variable should be same as Output text variable of Output Data Table activity.

Output text

Step 13: At last the process is ready. Now we can Run the process and the output will be displayed in the Message Box as below.

Message box

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