Get a Column

Retrieves a specified column from a table.

Overview

This procedure gets a column from a table, given the column's name. The data is returned as a single-column table. To get a list of values from a column instead, see the procedure Get a Column's Values.

Input Concepts

Concept	Type	Description	Default	Required
column name	string	The name of the column to retrieve.	No default	Yes

Output Concepts

Concept	Description
column	The specified column from the table.

Examples

In the examples below, the table refers to the following table, which can be generated using the create a sample table procedure:

Name	Number	Address	City
john	+ 1 [phone]	123 east street	San Francisco
joe	+ 1 [phone]	321 west street	San Jose
jack	+ 1 [phone]	213 north street	San Francisco

1. Syntax 1

Automation

get the table's column where
  the column name is "Address"

Results

Address
123 east street
321 west street
213 north street

2. Syntax 2

Automation

get the table's "Address" column

Results

Address
123 east street
321 west street
213 north street