Class 7
Mini-Cases in Automation: Part 1
Description
This class is set around two mini-cases that work with loops to automate the processing of spreadsheet data. The first covers data retrieval from a web source and filters the data to a spreadsheet output. The second case joins two spreadsheet sources together using a loop. This class extends the discussion by working directly with cases that require loops to process data. All of the steps in these example cases are deterministic, and do not require the use of an agent.
Motivation
The cases in this class are end-to-end examples that collect, join and loop through data, these are some of the most fundamental steps in any RPA solution.
Review
In the last class, we discussed design principles for automation workflows and covered concepts relating to the level of autonomy in a process, the role of agents versus RPA bots and humans-in-the-loop. In this class we will work through two cases that apply some of these design principles and concepts, but focus on the implementation of loops to process data.
Class plan
- After a brief review, we will work on the first case. This case will gather data from a web table on wikipedia, filter it, clean it up and output a spreadsheet with numerical values. Finally, in this case, we will work through adding some calculations.
- The second case will join two spreadsheets together using a loop. This is a common task in many RPA solutions, and is often done using a loop to compare values across two spreadsheets and output a joined spreadsheet based on the results of the loop.
- We will work through some sections as a class and some independently.
Materials
-
Class 7 slides (PDF)
Repository snapshot; original classroom version unverified.
View slides: Class 7 slides (PDF) -
Class 7 slides (PPTX)
Repository snapshot; original classroom version unverified.
View slides: Class 7 slides (PPTX)
Tools
- UiPath Studio Web, For Each, If/Else statements
- Spreadsheets, DataTables