Inserting a Data Calculator

A data calculator allows you to perform any kind of data transformations, by specifying an SQL query.

  1. Select the Data Calculator tool in the Toolbox, and create the action in the diagram.
  2. Select the Data Flow tool, and draw a flow from the preceding step (a data input or action) to the data calculator to initialize it with the incoming data structure columns.
  3. Double-click the data calculator symbol to open its property sheet, click the Criteria tab, and enter the appropriate SQL script to perform the desired data transformation.


  4. [optional] Click the Data Structure Columns tab, and add, edit, reorder or delete columns as appropriate.
  5. Click OK to save your changes and return to the diagram.
Note:

You can right-click a data calculator symbol, and select Criteria to access the Criteria tab directly.