Adding a data calculator

  1. Click the Transform tab in the Component Store.

  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:

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

    • The Data Calculator window appears.

    The Data Calculator window has a Tabular and Graph views:

    • Use the Tabular view to enter transformation rules.

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

  3. Click the Graph tab. Two sections — IN and OUT 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 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. 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. Select File | Save.