Skip to content

Advanced settings page

Application database > Analytical Workspaces tile > workspace tile > (Data Transformation Package tab) DTP tile > > Operations > (Operation type) Advanced settings

Purpose of the page

This page allows you to insert ranges as condition column values. In particular, it allows you to specify the value with which to enrich a target dataset field if another field of the same dataset is less than, less than or equal to, greater than, or greater than or equal to the threshold values indicated in the source field of the reference dataset.

Page sections

Element Description
List of relationships Shows a list of the operation's conditions.
Attributes Allows you to define the target field of the operation results and the ranges on the condition column values.
Operation information Shows contextual information on the operation. - Code: operation code - Description: operation description - Type: operation type

Relationship definition

Element Description
Target field Allows you to select the target dataset field.
Operator With Reference dataset enrichment operations, it allows you to select the allocation operator. - > - => - < - <= These operators therefore define the relationship between the target dataset and the reference dataset.
Source Allows you to indicate the source dataset field with which the enrichment will be run. It can be defined with a field code of the dataset or an SQL formula that calculates its value.