Download the PDF - Support

Transcript
Chapter 8: Stages Reference
4. Click OK.
5. If you want to specify additional rules for this condition, click Add Rule.
If you add additional rules, you will have to select a logical operator to use between each rule. Choose
And if you want the new rule and the previous rule to both pass in order for the condition to be met
and the associated actions taken. Select Or if you want either the previous rule or the new rule to
pass in order for the condition to be met.
6. Click the Actions node in the tree.
7. Click Add Action.
8. Complete the following fields.
Option
Description
Source type
Specifies the type of data to copy to the best of breed record. One of the
following.
Field
Choose this option if you want to copy a value from a field
to the best of breed record.
String
Choose this option if you want to copy a constant value
to the best of breed record.
Source data
Specifies the data to copy to the best of breed record. If the source type
is Field, select the field whose value you want to copy to the destination
field. If the source type is String, specify a constant value to copy to the
destination field.
Destination
Specifies the field in the best of breed record to which you want to copy
the data specified in the Source data field.
Accumulate source data If the data in the Source data field is numeric data, you can enable this
option to combine the source data for all duplicate records and put the
total value in the best of breed record.
For example, if there were three duplicate records in the group and they
contained these values in the Deposits field:
100.00
20.00
5.00
Then all three values would be combined and the total value, 125.00,
would be put in the best of breed record's Deposits field.
9. Click OK.
10. If you want to specify additional actions to take for this condition, click Add Action and repeat the
above steps.
11. To add another condition, click the root condition in the tree then click Add Condition.
Example Best of Breed Rule and Action
This Best of Breed rule selects the record where the Match Score is equal to the value
of 100. The Account Number data that corresponds to the selected field is then copied
to the AccountNumber field on the Best of Breed record.
Rule
Field Name: MatchScore
Field Type: Numeric
Operator: Equal
Value Type: String
Value: 100
Action
Data Quality Guide
153