Get Column

Get Column

Type: get-column  ·  Package: DataTable Activities v1.0.5  ·  Output: List

Returns all the values of a column as a list.

How it works

Walks the table and returns the values of the column, in row order and with the column’s type. Empty cells become null. If the column does not exist, it fails with a clear message listing the available columns. It does not modify the table.

Required parameters

Parameter	Type	Default	Description
table	DataTable	—	The DataTable to read from, e.g. customers.
column	string	—	Column name.

Optional parameters

None.

Output

Returns a List (List<object>) with one item per row. A table with no rows gives an empty list.

Common errors

Message	Cause and fix
'table' must be a DataTable.	table does not evaluate to a DataTable.
'column' is required.	The column name is missing.
Column '…' does not exist. Available columns: ….	The name does not match any column. Use one of those listed in the message.

Example

Get all the emails and join them into a single string:

Get Column   table = customers   column = "Email"   → output: emails

Log   message = "Recipients: " + join(emails, "; ")

Combine with list activities

The output is a list, so you can use it with List Count / List Contains or with LINQ expressions (emails.Where(...)). To summarize a numeric column (sum, average, maximum…), use Aggregate Column instead.

Related activities

• Aggregate Column — sum/average/count a column.
• Collections — operate on the resulting list.
• Get Cell — read a single cell.