Data Manipulation with Data Tables Flashcards
What activity creates a DataTable according to a specified schema?
Choose one of the options below.
Generate Data Table from Text
Read CSV
Build Data Table
Read Range Workbook
Build Data Table
What activity retrieves a value from a row in a DataTable according to a specified column?
Choose one of the options below
Lookup Data Table
Filter Data Table
Get Row Item
Update Row Item
Get Row Item
What activity can we use to create a new DataTable based on filtered values from an existing one?
Choose all applicable answers.
Merge Data Table
Output Data Table
Filter Data Table
Generate Data Table From Text
Sort Data Table
Filter Data Table
What is the key difference between data tables and spreadsheets?
Choose one of the answers.
Data Table cells are identified through the Column Name or Column Index and by the Row Index, both starting from zero. A spreadsheet cell is identified by a column letter and a row number starting at one.
Data Table cells are identified through the Column Name or Column Index and by the Row Index, both starting from one.
Data Table cells are identified by a column letter and a row number starting at one. A spreadsheet cell is identified through the Column Name or Column Index and by the Row Index, both starting from zero.
There’s no particular difference. We can use both of them depending on our business requirements.
Data Table cells are identified through the Column Name or Column Index and by the Row Index, both starting from zero. A spreadsheet cell is identified by a column letter and a row number starting at one.
What activity is used to create a DataTable from structured text, by letting the user indicate the row and column separators?
Choose one of the answers.
Build Data Table
Read Range
Read CSV
Generate Data Table From Text
Generate Data Table From Text
How can we convert a data table to a string?
Choose one of the answers.
By using the Merge Data Table activity.
By using the Generate Data Table from Text activity.
By using the Output Data Table activity.
By using the Build Data Table activity.
By using the Output Data Table activity.
What is a DataTable variable?
Choose one of the answers.
A type of variable that can store big pieces of information, and act as a database or a simple spreadsheet with rows and columns.
A type of variable which enables you to store multiple values of the same type.
A type of variable used to store numeric information. They can be used to perform equations or comparisons, pass important data, and many others.
A type of variable that can store only strings. These types of variables can be used to store any information such as employee names, usernames or any other string
A type of variable that can store big pieces of information, and act as a database or a simple spreadsheet with rows and columns.
What activity can you use to write a data table to a string variable?
Choose one of the answers.
Merge Data Table
Write Range
Generate Data Table
Output Data Table
Output Data Table
How can we combine rows from two tables by using values common to each other according to a rule?
Choose one of the answers.
By using the Remove Duplicate Rows activity
By using the Join Data Tables activity
By using the Merge Data Table activity
By using the Sort Data Table activity
By using the Join Data Tables activity
What container do you need to add to be able to use Modern Excel activities?
Choose one of the answers.
Use Application/Browser
Use Excel File
No container is needed
Excel Application Scope
Use Excel File
What are some of the activities that you can use to create a DataTable?
Choose all applicable answers.
Generate Data Table From Text
Read CSV
Build Data Table
Write Range Workbook
Read Range Workbook
Generate Data Table From Text
Read CSV
Build Data Table
Read Range Workbook
Which activity would be your first choice to loop through all the rows of a data table?
Choose one of the answers.
For Each Row in DataTable
Filter Data Table
For Each
Get Row Item
For Each Row in DataTable
