Lesson 3 - Data Manipulation
Get Row Item
Gets a value from a DataRow variable according to aspecified column.
参考链接:https://activities.uipath.com/docs/get-row-item
UIPATH.SYSTEM.ACTIVITIES Get Row Item
Single choice
(32) What activity can you use to get the value from acertain cell, from a specific data table row?
Get Row Item(√） Write Cell Read Cell Remove Data Row
eg（Lexmark）
expression
Multiple Choice
(33) If currentRow represents a row from a DataTablewith two column in this order: Name and Age, what expression can be used toobtain the value from the column Age?
currentRow("Age") (√） currentRow.Age currentRow(2) currentRow(1) (√）
Multiple Choice
(34) How can you identify a column in a data table?
Using the column name (√）
Using the rowname
Using the rowindex
Using the column index(√）
Single choice
(35) What .Net method of the datatable object can beused to filter a table by a condition? Filter（×）Select(√） ToString（×）Clone
automatically create a variable
Single choice
(36) What key combination allows you to automatically create a variable from an activity’s property field?
Ctrl + A Ctrl + K(√）Ctrl + N Ctrl + P
variable type
DateTime
Single choice
(37) What variable type can you use to efficiently store the current time inside yourworkflows?
Array DateTime(√） Integer String
integer
Single choice
(38) How canthe index integer variable be displayed inside a Message Box activity?
“Current index is:“+ index.ToString(√）
“Currentindex is:“+index
“Current index is: $index”
“Current index is: + index.ToString”
string (expression )
Assign activity
Single choice
(39) Whatactivity can be used to modify the value of an existing cell in a DataTable?
Assign activity(√） Add Data Column activity
Modify Cell activity Add Data Row activity
the procedure of the assign activity
1. create an variable - rowIndex
2. Assign activity
Single choice
(40) What typeof variables can be used as output for the Read CSV activity?
Listvariables
DataTablevariables(√）
Arrayvariables
StringvariablesOutput DataTable activity
Single choice
(41) Which ofthe following statements are true regarding the Output DataTable activity?
Returns the data contained in a DataTable as astring in a csv format (√）
Writesa DataTable to an Excel file
Returns a DataTable object
Writes a DataTable to a csv file
data types
Collections category
Multiple Choice
(42) Which of the following data types are includedin the Collections category?
List (√）Array(√）Dictionary(√）Int32
Lists and Arrays
Array
For Each Row
Single choice
(43) Whatactivity can be used to loop through each row from a DataTable?
If Build DataTable Flow Decision ForEach Row(√）
Multiple Choice
(44) Whatactivities can be used to iterate through an Array?
Flow Decision While (√） For Each (√） ForEach Row
List
Multiple Choice
(45) Which ofthe following statements is true regarding Lists and Arrays?
List items can be added using an Add toCollection activity. (√）
You canadd any number of elements to an array.（×）
Youcan iterate through a List using a For Each loop activity. (√）
Array and List elements can be accessed byindex. (√）
