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.