Skip to main content

Remove Data Column

AutomatR.DefaultActivities.Datatable.RemoveDataColumn

The "Remove Data Column" activity in AutomatR is designed to remove a DataColumn from a specified DataTable. This activity is useful for dynamically managing the structure of DataTables within workflows, allowing the removal of unnecessary columns based on either the column index or name.

Properties​

NameDescription
Input
Column IndexEnter the index of the column to be removed from the DataTable. Integer variable or argument representing the index of the column.
Column NameEnter the name of the column to be removed from the DataTable. String variable or argument representing the name of the column.
Data TableEnter the DataTable variable containing the DataColumn to be deleted. DataTable variable or argument.
Misc
Display NameProvides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variable or argument containing the desired display name.
Optional
DelaySpecifies the amount of time (in seconds) to wait before executing the "Remove Data Column" activity. This can be useful for handling synchronization issues. Integer variable or argument containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1.

How to use:

  1. Drag and drop the "Remove Data Column" activity onto the workflow.
  2. Configure the properties by specifying either the column index or column name to be removed from the DataTable.
  3. Provide the DataTable variable containing the DataColumn to be deleted.
  4. Optionally, configure the delay and customize the display name.
  5. Execute the workflow to remove the specified column from the DataTable.

Example: Consider an example where the "Remove Data Column" activity is used to remove a column named "Salary" from a DataTable named "employeeData":

Remove Data Column:
  Display Name: "Remove Salary Column"
  Column Name: "Salary"
  Data Table: employeeData

In this example, the activity removes the "Salary" column from the "employeeData" DataTable. The modification is applied directly to the DataTable.