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.
About this task
To set the specific output for a data rule, open an existing
data rule or create a data rule. You can create a data rule either
by highlighting an existing rule definition and clicking Generate a Data Rule, or by running a test on an existing
rule definition, clicking view output, and
then clicking Save as a Data Rule. If you
generate a data rule from the test results, then the bindings you
specified for the test will be saved.
Procedure
- Open the data rule that you want to set the output elements
for from the Data Quality workspace by double-clicking
the data rule.
- Click the Bindings and Output tab.
- 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.
- Optional: If you want to omit duplicate output
records from the output tables, select Exclude Duplicates.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Click OK when you are finished
creating your expression.
- Optional: Click Edit to make changes to the expression after you add it to your output
specifications.
- 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.
- Click Save in the bottom right corner
of the screen when you finish specifying your output.
- 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.
What to do next
You can view the output of a specific data rule that you
have executed by highlighting the rule in the
Data Quality workspace and clicking
View Output in the
Tasks menu. You must run a data rule before you can see
any rule output.