COLUMN function
This topic describes the formula syntax and usage of the COLUMN function in the Data Quality Execute Formula transform.
Description
Returns the column number of a reference.
Syntax
COLUMN([reference])The COLUMN function syntax has the following argument:
- reference Required. The column or range of columns for which to return the column number.
Example
| Amphibian | Reptile | Bird | Mammal |
|---|---|---|---|
| Salamander | Tortoise | Eagle | Wolf |
| Formula | Description | Result |
|---|---|---|
COLUMN([Amphibian]) |
Column number of Amphibian column. | 1 |
COLUMN([Bird]) |
Column number of Bird column. | 3 |