Setting the output content for a data rule

You can specify the output that you want to see from particular columns in the output tables produced when you executed a data rule. The columns of the output table can contain the value of rule variables, the value of physical columns, metrics, statistics, and expressions made up of functions or arithmetic operations.

1. Open the data rule that you want to set the output elements for from the Data Quality workspace by double-clicking the data rule.
2. Click the Bindings and Output tab.
3. Click Output Content in the Select View menu on the left side of the screen, and select the output records you want to display in your output from the Output Records menu.
   Note: The default output type is Do not meet rule conditions. If you select Statistics Only, then no output details records are created.
4. Optional: If you want to omit duplicate output records from the output tables, select Exclude Duplicates.
5. Optional: Highlight any rule logic variables you want to include in your output on the Rule Logic Variables tab on the right side of the screen and click Add to Selected. Note: The rule logic variables will show up by default in the output workspace. You can remove any of the rule logic variables, by highlighting the variable, and clicking Remove.
6. Optional: Select any additional columns you want to show in your output on the Data Sources tab on the right side of the screen. You can select individual columns or the entire table by highlighting the data sources you want to add and clicking Add to Selected. To add a column from a table that is not part of your bindings or join keys for your rule logic variables, ensure that the Show items from bindings and join keys only box is not checked. This feature allows you to be very selective about the data you want to display in your output. For example, you can choose to add all the columns in a particular table to your output, or select just one or two.
7. Optional: Click the Expressions tab if you want to add an expression you created to the data rule or rule set. Highlight the expressions and click Add to Selected.
8. Optional: Click the Statistics and Attributes tab and select any additional attributes or statistics that you want to display in your output. For example, you can select System Timestamp if you want information about the time the data rule was run.
9. Optional: Click Add Custom Expression at the bottom of the Selected Columns section to add a new expression to your output. For example, you could create a rule to calculate that a checking balance added to a savings balance is equal to the total account balance. CHECKING + SAVINGS = TOTAL_BALANCE When you define the output columns of a rule, you can choose to include the checking column, savings column, and total_balance columns. You can now also include the expected total_balance by adding the expression CHECKING + SAVINGS as an output column. This will allow you to see both the TOTAL_BALANCE value as well as the expected total value as calculated by adding the checking and savings values together.
   1. Create your new expression in the Create New Expression section by typing out the expression or by highlighting functions and rule logical variables in the Tabbed Palette section and clicking Add to Expression.
   2. Click OK when you are finished creating your expression.
   3. Optional: Click Edit to make changes to the expression after you add it to your output specifications.
10. Go to the Output Content workspace and click the Move Up or Move Down buttons to move your columns into the order that you want.
11. Click Save in the bottom right corner of the screen when you finish specifying your output.
12. Optional: As you are putting together your output, you have the option to open your rule definition, validate the output selections you have so far, or view the output of the data rule by selecting Open Definition, Run, View Output, or Validate.