Setting output tables for a data rule

If you want to use output tables from data rules as data sources for other tasks, you can select user-named tables. You can use output from data rules for tasks like attaching output columns as bindings in other data rules, or generating reports.

1. Open the data rule that you want to set the output table for from the Data Quality workspace by double-clicking the data rule.
2. Click the Bindings and Output tab.
3. Click Output Table in the Select View menu on the left side of the screen.
4. Select a user-named output table.

   Table type	Description
   System Table Only	The default table type. When this option is selected, no user-named rule output table is associated with the rule.
   Simple User-Named Table	Simple user-named output tables are a read-only view of the rule output and can be used for the output of only a single rule.
   Advanced User-Named Table	Advanced user-named output tables are physical tables that contain copied records, which means that advanced tables require additional storage space. Advanced tables can share output from multiple rules.

5. Enter or select a name for the table.
   • For a simple user-named table, enter a name.
   • For an advanced user-named table, enter a new name or select an existing output table. If you use an existing output table, the columns that are output by this data rule must exist in the output table you select. In other words, the output columns of this rule can be a subset of the existing table columns. If the output columns from this data rule contain columns that are not part of the existing output table you select, you can choose to use the output columns of the existing output table instead.
6. Select the method you to update the output tables for each run:
   • Select Append if you want the output to be appended to the existing records in the table. For a simple table, enter the number of runs that you want the output table to contain the results for.
   • Select Overwrite to keep the output results from only the latest run.
7. Optional: Select Include in Project Data Sources if you want the output table to be available as a data source in the project.