The Data Calculator immediately displays the result of transformation rules, allowing you to verify incoming data, test transformation rules, and view the effect of rules on data output.
By default, output port values reflect IN-port values. Manually changing an input port attribute value affects only the data of the input port or output port buffer, allowing you to test transformation rules, and to see the results in the current output record. This is a convenient way to create test cases for transformation rules.
Use the Transformation Rule column to add, modify, or delete transformation rules. You can also edit single-line functions by changing the current attribute input field.
The graphic view mirrors the actual port structures. You cannot add or delete attributes in the graphic view.
To add a transformation rule, right-click anywhere in the Transformation Rule or Current Output Port column, and select Insert. You can now use the added rules for further assignments or calculations.
To delete a transformation rule, right-click a row in the Transformation Rule column, and select Remove.
To change the order of the transformation rules, right-click the row in the Transformation Rule column, and select Up or Down.
To add missing output attributes, click Mapping, and select Add missing output attributes.
Transformation rules are processed in sequential order. The processing starts with the first transformation rule of the list.