Add Column Activity
The Add Column activity enables the insertion of one or more columns into a specified dataset. This activity allows for precise structural modifications by defining column names and their positional placement within the data sequence.
| Field | Description | Requirement |
|---|---|---|
| Dataset name | The reference name of the target dataset to be modified. | Required |
| Column name | The name of the column to be added. Supports comma-separated values for multiple additions. | Optional |
| Column index | The zero-based numerical position where the column will be inserted. | Optional |
| Result variable name | The name of the variable that will store the output of the operation. | Optional |
Action Types & Examples
Single Column Addition
- Format: string
- Example Result: "Name"
Multiple Column Addition
- Format: string (comma-separated)
- Example Result: "Name,Surname"
Index Specification
- Format: digit or range
- Example Result: "0"
Implementation Examples
Field Setup
Dataset name:newDSColumn name:Name,SurnameResult variable name:resultVariable
Execution Parameters
Single index:0Range index:10:12Range index for three columns:4:6
Technical Notes
Column indexing begins at 0. If the Column index field is left blank, the activity appends the new column to the end of the dataset. When initializing an empty dataset, the index must be set to 0 to successfully create the first column. For multiple column additions, the index field must contain a range corresponding to the number of columns defined (e.g., a range of "4:6" for three columns).