Adding a data calculator

StepsTo add a data calculator

  1. Click the Transform tab in the Component Store.

  2. Select the Data Calculator Java Script component and drop it onto the link connecting the existing components. The color of the link changes to blue.

    After releasing the Data Calculator component:

    • The Data Calculator component is linked with the components to the right and to the left.

    • The Data Calculator window appears.

    The Data Calculator window has a Tabular and Graph view:

    • Use the Tabular view to enter transformation rules.

    • Use the Graph view to visually define the mapping sequence between the input port and the output port.

  3. Click the Graph tab. Two sections IN and OUT represent the current structure of the port attributes.

    You are prompted to assign a default mapping by order.

  4. Click Yes.

  5. Click the Tabular tab to return to tabular view.

  6. Change all incoming data for the PR_NAME attribute into uppercase letters:

    uUpper(IN.PR_NAME) ' OUT.PR_NAME
    
  7. Enter uUpper(IN.NAME) in the Transformation Rule column of the IN.PR_NAME attribute. Without any added function the IN.PR_NAME value is forwarded to the OUT.PR_NAME attribute.

  8. Click Save to confirm your settings. The green color of all ports in the project indicate that all components have been successfully configured.

  9. From the File Menu, select Save to save your project.