Creating derived fields
You can create fields from one or more existing fields, even across different data sources.
1.
From the configuration window of a process that supports derived fields, click Derived Fields.
The Create Derived Field window opens.
2.
All derived fields that were previously created in this process appear in the Field Name list. To create a new derived field, enter a different name.
3.
Select the Make Persistent check box if you want to store and pass on the calculated values for this field.
This option makes the derived field available to a subsequent process.
4.
Define the derived field directly in the Expressions area or use the Formula Helper. You can double-click an available field to add it to the Expressions area.
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.
A derived field can be a null value. Use NULL to return a null value for a snapshot. Use NULL_STRING to return a null value with a string data type if you want the derived field to be used with a Campaign macro.
You can enter a string in a derived field as a constant. If you use a string, it must be surrounded by double quotation marks. For example, "my string". Quotation marks are not required for numeric strings.
5.
(Optional) Click Stored Derived Fields if you want to be able to use the derived field in another process or flowchart.
You can also use this option to load an existing derived field or to organize the list of stored derived fields.
6.
Click Check Syntax to detect any errors.
7.
Click OK to save the derived field.
Copyright IBM Corporation 2015. All Rights Reserved.