Expression Editor Syntax for Column Transformations
Put column names in square brackets.
Note: For Birst experts, if
there is no need to add aggregation syntax, you can use the column name only.
[My Column Header]
Enclose strings in single quotes.
'Modeler'
Supported operators include:
=, <, >, <>, <=, >=, *, AND, OR, LIKE, NOT LIKE, IS NULL, IS NOT NULL, + (concatenate), % (modulo)
For more details, see the BQL and Expressions Reference PDF on ThinkTank.