Attribute transformation is an optional process that allows you to create attribute rules during the Transformer process. It is also available in the BDP, eliminating the need to return to the Transformer for additional attribute customization.
How Attribute Transformation Works
Attribute transformation rules modify an original data value within an attribute for your input data. The transformation happens on an "every occurrence basis" for specified attributes, unless a condition is included. Input actions are performed on input rows before data is copied to the output.
Note the following guidelines:
- Attribute transformation is not available for BDP output attributes.
- All attribute names used in input actions must exist in the input schema.
To add a new attribute transformation
-
From the Navigation or Quality Project View, right-click the Business Data Parser process and select Edit Process. The BDP editing window opens.
-
Click Input Conditionals. The Input Transformations window displays.
-
Right-click in the window's right pane and select Add >New >Attribute Transformation. The Set Attribute window displays.
-
In the Description field, enter a description for this transformation rule.
-
Click the Set attribute drop-down list and select an attribute you want to transform.
-
To create the rule expression, do one of the following:
- Use the Expression Builder tool: To the right of the to expression field, click the build expression button (). The Set Attribute to Expression window opens. Enter the expression elements in the text field. Click OK.
- Enter the expression elements directly into the to expression field.
-
Click Finish to save your settings.
The rule displays in the right window.
-
(Optional) To make rule edits or deletions, right-click the row and select Edit... or Delete. For more information, see Editing Transformation Rules.
-
(Optional) To create a duplicate version (essentially a clone) of a rule, right-click in the window's right pane and select Add > Existing. Select the rule you want to duplicate and click Add. For more information, see Reusing Transformation Rules.
-
(Optional) To set a condition that applies to the rule, right-click the conditional in the left pane and select Edit. The Edit Condition window opens.