RemoveColumn

This activity helps to remove a specified “Column” from the “Input datatable.”

Properties

INPUT

ColumnName:* Enter the “Column name” to remove from the “Input datatable.” Provide the column name within double quotes or input the variable in “string” datatype where the column name is stored. This field only accepts data in “String” datatype. If left blank, it will work with the “DataColumn” field if provided.

Datacolumn:* Enter the “Data column” where the input is stored to remove from the table. You can employ either the “ColumnName (hardcoded value)” or the “DataColumn (variable)” option to remove a column. This field accepts only “Datacolumn” datatype.
If left blank, it will work with the “DataColumn” field if provided.

DataColumnIndex:*  Specify the “Index” position of the data column within the “Datatable” that you want to remove. The index position starts from 0. This field accepts only “Integer” datatype. 

Datatable:* Enter the “Input datatable” variable where the input data is stored. This parameter helps you to remove the “Column” from the “datatable”. This field only accepts the “datatable” data type.

MISC

DisplayName: Displays the name of the activity. The activity name can also be customized to help in troubleshooting.

SkipOnError: It specifies whether to continue executing the workflow even if it throws an error. This supports only Boolean value “True or False”. By default, it is set to “False.”
True: Continues the workflow to the next step
False: The workflow aborts if it throws any error.
None: If the option is specified as blank, by default the activity will perform as “False” action.
Version: It specifies the version of the Datatable automation feature in use.

OUTPUT

Result: It helps to view the execution state of the activity. It returns the values in Boolean format.
True: It indicates the activity has been executed successfully without any error.
False: It indicates that the activity has been faulted due to some unexceptional error thrown.

* Represents mandatory fields to execute the workflow.