Get a Column Number

Gets the column number of a specified column in a table.

Overview

Retrieves the column number (index) of the specified column in a table.

Note: Columns are numbered starting with the number 0.

Input Concepts

Concept
Type
Description
Default
Required

column

column

The column whose index is to be retrieved.

No default

Yes

Output Concepts

Concept
Description

column number

The number of the column (index).

Examples

1. Example 1

In this example, the column refers to the Address column in the table below.

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

Note: This sample table can be generated using the create a sample table procedure.

get the column's column number

Since the columns are numbered starting at 0, the Address column has a column number (index) of 2.

Last updated

Was this helpful?