Adding a Data Calculator

  1. In the Component Store, click the Transform tab.

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

    After releasing the Data Calculator component:

    • It is linked with the components to the right and 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 IN-ports and OUT-ports.

  3. Click the Graph tab. The IN and OUT boxes represent the current structure of the port attributes.

  4. Click Yes to assign a default mapping by order.

  5. Click the Tabular tab to return to the 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.PR_NAME) in the Transformation Rule column of the IN.PR_NAME attribute. 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. Select File | Save.