User Tools

Site Tools


syntax:functions:columnexists

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

syntax:functions:columnexists [2020/07/06 11:07] (current)
dmitry created
Line 1: Line 1:
 +====== ColumnExists(text) ======
  
 +Returns TRUE if the input dataset of the current action contains a column with provided name, otherwise returns FALSE.
 +
 +Example:
 +
 +Let's assume the input dataset is as below.
 +^ Amount  ^ Description ^
 +|  200 | Product A  | 
 +|  3000| Product B  |
 +
 +
 +Then the function would return the following results:
 +
 +^ Expression  ^ Result^
 +|columnexists('Description'  | TRUE | 
 +|columnexists('Price'     | FALSE | 
syntax/functions/columnexists.txt · Last modified: 2020/07/06 11:07 by dmitry