Derivation Rule
RDG Derivation Rule enables the derivation of a single value based on the business conditions for the driving attribute values between the entities.
- Choose the Data Model, CR Type, and Entity at the top of the screen.
- Select the workflow step from the drop-down box in the middle of the screen.
- Select the attribute for the derivation and the expression. User-defined expression allows the creation of any number of conditions with any combination of and/or conditions. Select generate flow.
- Complete the conditions using values or attributes. In this example,
• If AD_POSTAL-REF-POSTA = “US”
• And AD_POSTAL-CITY1 = “DENVER”
• Then derive the attribute value AD_POSTAL-POST-COD1 = “80014” only for Initial processing step - Save the Rule Configuration, select TR and Package. Successful message should appear.
Click the formula table button. Choose either String Concatenation or Mathematical Formula and enter any combination of attribute values and fixed values as required. Optionally include a delimiter. - Save the Rule Configuration, select TR and Package. Success message should appear.