Audio version of the article
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.
Step 2: Double click on the Build Data Table activity. Then click on the Data Table button to create the 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.
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.
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.
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.
Step 7: Now for sorting the data we need to add the Sort Data Table activity into the Flowchart after Build Data Table activity.
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.
Step 9: Next we need to add Output Data Table activity which will convert the Data Table to a string.
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.
Step 11: After Output Data Table activity we need add Message Box activity for display the output as a text message.
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.
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.