User Tools

Site Tools


syntax:functions:columnexists

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

ArgumentTypeDescription
col_nameText 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