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 (415) 691 9426

123 east street

San Francisco

joe

+ 1 (415) 691 1234

321 west street

San Jose

jack

+ 1 (415) 691 4595

213 north street

San Francisco

1. Syntax 1

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

2. Syntax 2

get the table's "Address" column

Last updated

Was this helpful?