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