M.A.M.
SCHOOL OF ENGINEERING
Department of Artificial Intelligence & Data Science
Data Table
III Year/ VI Semester
CCS361 – Robotic Process Automation
Present by,
[Link]
Contents
• Build Data Table
• Clear Data Table
• Collection Data Table
Build Data
Table
Click icon to add picture
Configuration
[Link]
Creates a DataTable according to a specified schema.
Configuration (Contd..)
Clicking the DataTable button in the activity body opens the
Build Data Table window, which enables you to customize the
table to be created.
Configuration (Contd..)
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.
In the Properties Panel
Options
1. DisplayName - The display name of the activity.
2. Private - If selected, the values of variables and arguments are no longer
logged at Verbose level.
Output
3. DataTable - A DataTable variable that stores the information added in the
Build Data Table window.
Clear Data Table
Click icon to add picture
Configuration
[Link]
Clears all the data in the specified DataTable.
In the Properties Panel
Options
• DataTable - The DataTable object to be cleared of all data.
• DisplayName - The display name of the activity.
• Private - If selected, the values of variables and arguments are no longer
logged at Verbose level.
Collection Data Table
Click icon to add picture
Configuration
[Link]
Converts a specified collection to a DataTable.
Windows, Cross-platform
configuration
Options
• Collection - The collection to be converted into a DataTable.
• Items - The items to be added. Click the field to open the Collection Builder
window.
NOTE: Changing the data type of the collection after selecting it in the Collection
field triggers a validation error. The collection with the new data type must be
added again to the activity.
• Additional options
Output
• DataTable - Reference to the resulting DataTable for use in other activities.
Windows - Legacy configuration
Properties panel
Common
• DisplayName - The name of the activity in the Designer panel.
Input
• Collection - The collection to be converted into a DataTable.
Misc
• Private - If selected, the values of variables and arguments are no longer
logged at Verbose level.
• TypeArgument - A drop-down list that enables you to choose what .NET
datatype you want to use with the activity.
Output
• DataTable - Reference to the resulting DataTable for use in other activities.
Questions & Answers
Thank you all