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 [phone]	123 east street	San Francisco
joe	+ 1 [phone]	321 west street	San Jose
jack	+ 1 [phone]	213 north street	San Francisco

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

Automation

get the column's column number

Results

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