A data calculator allows you to perform any kind of data transformations, by specifying an SQL query.
- Select the Data Calculator tool in the Toolbox, and create the action in the diagram.
- 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.
- 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.
- [optional] Click the Data Structure Columns tab, and add, edit, reorder or delete columns as appropriate.
- 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.
