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. (√）
