To specify a column
expression:
-
On the
Column
Editor tab, select
table-name.column-name from
the
Expression column. If you added a new
column manually, then you need to specify the table and column name.
-
Click
to open the expression builder. The table and column
name are added automatically as the default expression.
-
Use the
Fields tab
to select columns from the source tables that you have added to the
query.
Tip
You can also begin entering
the table and column name in the expression window to use the autocomplete
feature.
-
Use the
Functions tab
to 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.