Question 15

Explanation

UiPath offers a broad range of activities that can be used to work with DataTable variables:

Add Data Column

Adds a column to an existing DataTable variable. The input data can be of DataColumn type or the column can be added empty, by specifying the data type and configuring the options (allowing null values, requesting unique values, auto-incrementing, default value and maximum length).

Add Data Row

Adds a new row to an existing DataTable variable. The input data can be of DataRow type or can be entered as an Array Row, by matching each object with the data type of each column.

Build Data Table

Is used to create a DataTable using a dedicated window. This activity allows the customization of number of columns and type of data for each column.

Clear Data Table

Clears all the data in an existing DataTable variable.

Filter Data Table

Allows filtering a DataTable through a Filter Wizard, using various conditions. This activity can be configured to create a new DataTable for the output of the activity, or to keep the existing one and filter out (delete) the entries that do not match the filtering conditions.

For Each Row

Is used to perform a certain activity for each row of a DataTable (similar to a For Each loop).

Generate Data Table

Can be used to create a DataTable from unstructured data, by letting the user indicate the row and column separators.

Join Data Tables

Combines rows from two tables by using values common to each other, according to a Join rule that answers the question "What to do with the data that doesn't match?". It is one of the most useful activities in business scenarios, where working with more than one Data Table is very common. This is why we'll cover in more in depth below.

Lookup Data Table

Is similar to vLookup in Excel, as it allows searching for a provided value in a specified DataTable and returns the RowIndex at which it was found, or can be configured to return the value from a cell with given coordinates (RowIndex and Target Column).

Merge Data Table

Is used to append a specified DataTable to the current DataTable. The operation is more simple than the Join Data Type activity, as it has 4 predefined actions to perform over the missing schema.

Output Data Table

Writes a DataTable to a string using the CSV format.

Remove Data Column

Removes a certain column from a specified DataTable. The input may consist of the column index, column name or a Data Column variable.

Remove Data Row

Removes a row from a specified DataTable. The input may consist of the row index or a Data Row variable.

Remove Duplicate Rows

Removes the duplicate rows from a specified DataTable variable, keeping only the first occurrence.

Sort Data Table

Can sort a DataTable ascending or descending based on the values in a specific column.

https://docs.uipath.com/activities/docs/add-data-column