Enrichment with formula

Function

The Enrichment with formula operation allows you to define the fields of a dataset using SQL formulas. In addition to the formula, it is possible to specify a condition to be checked in order to apply the formula.

If the condition...	Then...
is checked	the system will apply the formula defined in the SQL formula field. This formula is also applied if no condition is defined.
is not checked	the system will apply the formula defined in the Alternative SQL formula field.

Syntax in formulas

Recursive formulas can be defined within the same operation, by inserting the reference to another target field in the SQL formula field (or the Alternative SQL formula field), using the syntax @destination_field@. In this case, the system replaces the expression @destination_field@ with the field relationship present in the target field destination_field.

That syntax cannot be used to refer to a target field if no explicit relationship with the source field has been defined in the target field. It is always possible to cite the destination_field as the table field. To do this, simply omit the special character @.

In case of circular references in the definition of target fields, the system shows a message with details of the fields involved. In case of Analytical Workspace parameters and target fields with the same name in the dataset, the Analytical Workspace parameters prevail.