Creating a derived field from an existing one
You can create a new derived field by basing it on an existing derived field, then changing the expression.
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.
1.
From the configuration window of a process that supports derived fields, click
Derived Fields
.
The Create Derived Field dialog opens.
2.
From the
Field Name
list, select an existing derived field.
The expression for the selected field appears in the
Expression
area.
3.
Change the name of the existing derived field to the name that you want to use for the new derived field.
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.
4.
Edit the derived field expression.
5.
Click
OK
.
Copyright IBM Corporation 2015. All Rights Reserved.