Category: Special function
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.
| Argument | Type | Description |
|---|---|---|
| col_name | Text | The name of a column to test for within the input dataset. |
Return value type: Boolean (TRUE/FALSE)
This function is case sensitive.
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