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