The Export to Calculation Table will export the data, according to the rules applied, to a Calculation Table that has been applied to a Project.
The data exported will only be available in the current specification from which it was started.
The Calculation Table to export into must exist in the project.
With your project open in DriveWorks Administrator go to Stage 4. Output Rules> Documents.
Click the cell in the Field Type column adjacent to the Field Name that is to be the control field. Select Control from the drop down list.
Control Fields control whether a row is inserted, updated, or ignored:
Click the cell in the Field Type column adjacent to the Field Name that is to be a common field. Select Common from the drop down list.
Common Fields make it easier when exporting multiple rows where certain columns have the same value in each row.
For example a Discount column might always contain the value 10%.
For these columns, you may only want to build one rule, instead of a separate rule for each row. To do this, mark the column as a Common Field, and DriveWorks will automatically use the same rule for the column in all rows.
Click the cell in the Is Captured column adjacent to the Field Name and choose No from the drop down.
This option applies:
The behaviour for the setting is as follows:
Once the document has been created it will open in the editor for adding rows to export and building rules for each cell in that row.
To allow rules to be built for the export a row must be added to the Data Export Rows table.
Click the Add Row button to add a new row to export.
A number 1 will appear in the first row.
Subsequent row additions will create incremental rows.
With a row added, each cell can have a rule built for the export.
Select the cell to have a rule applied and click the Build button, from the command bar, to launch the rule builder.
To remove a row select a cell that belongs to the row to remove an click the Remove Row button from the command bar.
To adjust the settings made for the initial table columns click the Edit Table Columns button from the command bar.
Used in ODBC Data Export. Allow the same rule to be built for fields where multiple rows exported. See ODBC Data Export for more information.