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 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
Fields tab,
select columns from the source tables that you have added to the query.
Tip
You can begin entering the
table name and column name in the
SQL expression area
to use the autocomplete feature.
-
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.