Enrichment with formula field

Function

The Enrichment with formula field operation allows you to enrich a field of a target dataset using an SQL formula defined on a formula field present on the same row as the field to be enriched.

It is not possible to run updates with formulas containing keywords corresponding to commands such as DROP, UPDATE, and so on, or special characters that indicate the opening of a comment or the closing of an SQL statement.

Rows containing a formula with null value will not be edited.

Example

This example considers the following target dataset:

The operation is set up so that the formula in the Formula field is applied to define the content of the Target field. Once the operation has been run, the dataset will contain the following values:

The first row of the target field contains the concatenation of the values contained in Field A and Field B given that the first row of the Formula field specifies the formula Field A + Field B.

However, after having concatenated the values of Field A and Field B (A and B, respectively), the second row calculates the length of the result, given that the Formula field of the second row contains the formula length(Field A + Field B).