To specify a column
expression:
-
On the
Column
Editor tab, specify a name for the column.
-
Select
table-name.column-name
from
the
Expression column. If you added a new
column manually, then you must make sure that you specified a table
name and a column name.
-
Click
to open the expression builder. The table name and
column name are added automatically as the default SQL expression.
-
-
On the
Functions tab, select the functions to apply to the
source column.
-
Enter arithmetic
operators and expressions such as CASE statements directly in the
SQL
expression area.
-
Click
Apply to
save the column expression.
Note: If you click
after you click
Apply, then
your last change to the expression is undone. However, because the
expression window is closed, you might not notice the undo.