syntax:functions:columnexists
Table of Contents
ColumnExists(col_name)
Category: Special function
Description
This function tests whether a column named col_name exists in the input dataset. TRUE is returned if the named column exists, otherwise, FALSE is returned.
Arguments
| Argument | Type | Description |
|---|---|---|
| col_name | Text | The name of a column to test for within the input dataset. |
Return value type: Boolean (TRUE/FALSE)
Remarks
This function is case sensitive.
Examples
Sample dataset:
| Amount | Description |
|---|---|
| 200 | Product A |
| 3000 | Product B |
Given the dataset above, ColumnExists() would return the following results:
columnexists('Description') = TRUE
columnexists('description') = FALSE //Function is case-sensitive
columnexists('Price') = FALSE
syntax/functions/columnexists.txt · Last modified: 2021/09/12 11:29 by craigt