You can create a new derived field by basing it on an existing
derived field, then changing the expression.
About this task
Only fields from tables that are selected in the process
configuration dialog can be used in a derived field expression. If
a desired table does not appear, make sure it is selected as a source
table.
Procedure
-
From the configuration window of a process that supports derived fields, click
Derived fields.
The Create Derived Field dialog opens.
-
From the Field name list, select an existing derived field.
The expression for the selected field appears in the Expression area.
- Change the name of the existing derived field to the name
that you want to use for the new derived field.
Important: You cannot use the words "Yes" or "No" as names for
derived fields. Doing so results in database disconnects when these
derived fields are called.
- Edit the derived field expression.
- Click OK.