Add Data Column

Adds a new column of a specified data type to an existing DataTable.

Behaviour

Risk: Low · Idempotent: No · Safe to retry: No · Recovery: Not replayed after a crash

Package System activities VeloPhex.System.Activities 0.7.1-rc.12 · Supported (Core profile) · type id velophex.system.addDataColumn

Properties#

Input#

Data Table#

DataTable · DataTable · Required · Default: Not specified in package metadata

The DataTable to which the column will be added.

Column Name#

ColumnName · String · Optional · Default: Not specified in package metadata

The name of the column to add. Required unless Column is set.

Data Type#

DataType · String · Optional · Default: String

The .NET type for values in this column.

Allowed values: String, Int16, Int32, Int64, Byte, Single, Double, Decimal, Boolean, DateTime, DateTimeOffset, TimeSpan, Guid, Object.

Default Value#

DefaultValue · Object · Optional · Default: Not specified in package metadata

The default value assigned to this column for existing and future rows.

Allow Null#

AllowNull · Boolean · Optional · Default: True

Specifies whether the column allows null (DBNull) values.

Auto Increment#

AutoIncrement · Boolean · Optional · Default: False

New rows get the next number (from 1, step 1). The column must be an integer type.

Max Length#

MaxLength · Int32? · Optional · Default: Not specified in package metadata

The longest value a String column accepts. Empty: no limit.

Unique#

Unique · Boolean · Optional · Default: False

Each row's value in this column must differ from every other row's.

Options#

Column#

Column · DataColumn · Optional · Default: Not specified in package metadata · Advanced

A DataColumn to add as it is, in place of Column Name, Data Type and the options.

Output#

Output Data Table#

OutputDataTable · DataTable · Output

The modified DataTable instance.

Rules#

• Set only one of: Column Name, Column.

Retry and risk#

This activity is not marked safe to retry: if it fails partway, check whether its work already happened before running it again. If a run is interrupted and the outcome of a step is unknown, the step is never retried automatically (what to do). How activities declare this: characteristics, retries and risk.

Every activity also has the engine's common properties: Timeout and Continue On Error.

Related activities#

• Add Data Row
• Build Data Table
• Clear Data Table
• Filter Data Table
• Generate Data Table From Text
• Get Row Item
• Join Data Tables
• Lookup Data Table

Generated from VeloPhex.System.Activities 0.7.1-rc.12. Category: Data Table. Keywords: datatable, column, add, create, schema.

Properties

Input

Options

Output

Rules

Retry and risk

Related activities