Build Datatable

This activity is used to create a DataTable with configurable rows and columns. It allows users to define the table structure by specifying column names, data types, and optionally adding initial rows of data for use within automation workflows.

Properties

Input

Datatable Wizard *:

Used to define the structure and content of the DataTable by configuring its columns and optional data rows.

Column Name: Specifies the name of the column to be added to the DataTable.

Data Type: Allows you to select the data type for the column from the dropdown list (e.g., String, Int32, Boolean, DateTime).

Allow Null: Specifies whether the column can contain null values.

Auto Increment: Enables automatic incrementation of numeric values for each new row (applicable for numeric columns only).

Default Value: Specifies the default value to be assigned if no data is provided for that column.

Unique: Indicates whether all values in the column must be unique.

Max Length: Defines the maximum number of characters allowed in the column (applicable for String datatype).

MISC

Display Name: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”

True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

Output

Datatable: Returns the output as a structured table format with the input provided.

Result: This parameter allows you to view the execution status of the activity and returns a value in “Boolean.”

True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown

* Represents mandatory fields to execute the workflow.

Note: 

This activity cannot be used at runtime to dynamically pass values for building a DataTable. To create or generate a DataTable during runtime, use the Generate Table From Text activity instead.