Remove Column Activity
The Remove Column activity enables users to delete a specified column from a dataset. This action modifies the dataset by permanently removing the column identified by its name, index, or a defined range.
| Field | Description | Requirement |
|---|---|---|
| Dataset name | The reference name of the dataset from which the column will be removed. | Required |
| Column | The identifier for the column to be removed. This can be a column name, a numerical index, or a range of indices/letters. | Required |
Action Types & Examples
Column by Index
- Format: Digit
- Example Result:
0
Column by Name
- Format: String
- Example Result:
"Name"
Column by Letter Range
- Format: String (e.g., "A:C" for columns A through C)
- Example Result:
"A:C"
Column by Index Range
- Format: String (e.g., "0:4" for columns with index 0 through 4)
- Example Result:
"0:4"
Implementation Examples
Field Setup - Dataset name: newDS
Execution Parameters - Column: 0 - Column: "Name" - Column: "A:C" - Column: "0:4"
Technical Notes
The activity requires precise identification of both the target dataset and the column to be removed. Column identification supports numerical indices, column names, and index/letter ranges for flexible removal operations. Ensure the specified column or range exists within the dataset to prevent execution errors.