UiPath Flashcards
What are the 4 ways to create DataTables?
- Build Data Table
- Read Range - gets content of worksheet and store data in data table
- Read CSV
- Data Scraping
BRRD (Big bird picking up data table and flying away)
What does the Lookup Data Table function do?
- Search for value -> returns row index
- Give coordinates of cell -> returns value
SerGeant Lookup
What does Output DataTable function do?
Writes data table to string using csv format
List 3 business scenarios where Join Data function is useful?
- Combine 2 databases of employees extracted from 2 applications
- Check which clients (DB1) have been contacted in a marketing campaign (DB2)
- Check which of the suppliers of a company (internal DB) have applied for public aid (public DB).
What are the differences between the two input methods: “Send Windows Messages” and “Simulate”?
Both work in the background (default does not)
Send Windows Messages: Replays the window messages that the target application receives when the mouse/keyboard is used. Slower, but less compatability issues.
Simulate: Uses the technology of the target application (API level). Faster, but some compatability issues.
What is the default input method when interacting with User Interfaces? Strengths/weaknesses?
Actually clicks the mouse and uses the keyboard to enter input.
Can’t touch computer while it’s working.
Slower, but has 100% compatability.
What is an input action as it relates to User Interfaces and what are the 4 types?
It’s any time we insert data into an application, or we send a command to a system to produce a change (or a continuation)
Types: Click, Type Into, Send Hotkey, Hover
What is IMAP?
Internet Message Access Protocol
Used to receive e-mail from mail server
Name 3 characteristics that make a process more suitable for RPA automation?
- Repetitive
- Rule-based
- Stable
Name 3 factors that increase the complexity of a potential automation?
- Number of decision points in business logic
- Legacy Applications
- Inputs that cannot be standardized
What value will the following expression return?
String.Format(“{1} is {0}”, “home”, “John”, “far away”, 0, 1)
“John is home”
What are the 6 steps of RPA implementations?
Prepare RPA, Solution Design, Build RPA, Test RPA, Stailized RPA, Constant improvement
Consider a dictionary variable (birthDates), of type String, String, that contains name and birth date pairs. They key values are the names. You want to add a new key / value pair using an Assign Activity (John Doe, Apr/20/1980).
What expressions would you enter in the To and Value fields of the Assign activity?
To: birthDates(“John Doe”) Value:”Apr/20/1980”
What activity can you use to create a data table from unstructured data?
Generate Data Table. This allows you to use files that may be separated by pipes, spaces, etc…
Can Excel related activities run on a machine that does not have the Excel application installed?
Yes, but only for XLSX files
The last X (xlsX for xls) means that it follows the XML standards
XLSX files is smaller than XLS