UiPath Activities Guide

Build Data Table

UiPath.Core.Activities.BuildDataTable

Creates a DataTable according to a specified schema.

Activity Body

Clicking the DataTable button in the activity body opens the Build Data Table window, which enables you to customize the table to be created.

By default, two columns and two rows are displayed. The first row contains some values that can be edited. The second row cannot be removed, but it is not displayed in the output table. The default column titles and variable types cannot be edited. Instead, the columns have to be removed and then replaced by new ones.

Clicking the Add Column add_column button opens the New Column window. It helps you create and customize each new column you want to add to the data table. After creating a new column, you can edit its properties by clicking the Edit Column edit_column button.

Note:

Changing the data type of a column erases all data in that column.

It contains the following fields:

  • Column Name - The title of the column. This field supports only strings.
  • Data Type - The type of values that the new column is going to accept.
  • Allow Null - If this check box is selected, null values can be added to the rows of this column.
  • Auto Increment - The check box is displayed only if the Data Type is set to Int32. If selected, the value of this column is automatically incremented by 1 every time a new row is added.
  • Default Value - The default value of all the rows that are to be added to this column.
  • Unique - If selected, all the rows in this column need to have unique values.
  • MaxLength - The maximum number of characters accepted for this column. If you do not want to enforce a maximum length, the default value is -1.

Properties

Output

  • DataTable - A DataTable variable that stores the information added in the Build Data Table window.

Common

  • DisplayName - The display name of the activity.

Misc

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Example of using the Build Data Table activity

You can see how the Build Data Table activity is used in an example that incorporates multiple activities and it is used for managing multiple databases. You can check and download the example from here.


Build Data Table


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.