DataFlux Data Management Studio 2.5: User Guide

Calculated Field Node

You can add a Calculated Field node to a data job to calculate a score from any number of incoming numeric fields and a selected algorithm. Then the resulting score is placed in a new column. Each field included in the calculation is assigned a weight that determines how much impact it has on the resulting score.

Once you have added the node, you can double-click it to open its properties dialog box, which includes the following elements:

Name - Specifies a name for the node.

Notes - Enables you to open the Notes dialog box. You use this box to enter optional details or any other relevant information for the input.

Available Fields - Specifies the fields that you can make available for the score calculation. (If you select fields that cannot be parsed into a number, they are treated as 0.) Items displayed in this list are dependent on your data sources and any preceding steps in your data job.

Selected Fields - Specifies the fields that are used in the score calculation. You can add fields more than once and in any order. You can also set a weight for each field in the calculation here. For example, a field assigned a weight of 2 has twice the impact as a field with the assigned weight of 1. The default weight is 1. Also note that the order of the fields selected determines the sequence in which the selected operation is applied. For example, if you select 8, 4, and 2, with an operation of Quotient, your result is (8 / 4 / 2) = 1.

Operation - Specifies the operation used for the calculation. The following operations are available:

• Difference
• Maximum
• Mean
• Minimum
• Product
• Quotient
• Sum

Output Field - Specifies the name of the column that contains the calculated score. If no value is entered, the column name is empty.

You can access the following advanced properties by right-clicking the Calculated Field node:

• INPUT_FIELDS
• OPERATION
• OUTPUT_COL