1
Download the PDF - Support
Transcript
Chapter 5: Deduplication Option Description Contains Determines if the field contains the value specified. For example, "sailboat" contains the value "boat". Equal Determines if the field contains the exact value specified. Greater Than Determines if the field value is greater than the value specified. This operation only works on numeric fields. Greater Than Determines if the field value is greater than or equal Or Equal To to the value specified. This operation only works on numeric fields. Highest Compares the field's value for all the records group and determines which record has the highest value in the field. For example, if the fields in the group contain values of 10, 20, 30, and 100, the record with the field value 100 would be selected. This operation only works on numeric fields. If multiple records are tied for the longest value, one record is selected. Is Empty Determines if the field contains no value. Is Not Empty Determines if the field contains any value. Less Than Determines if the field value is less than the value specified. This operation only works on numeric fields. Less Than Or Determines if the field value is less than or equal to Equal To the value specified. This operation only works on numeric fields. Value type Longest Compares the field's value for all the records group and determines which record has the longest (in bytes) value in the field. For example, if the group contains the values "Mike" and "Michael", the record with the value "Michael" would be selected. If multiple records are tied for the longest value, one record is selected. Lowest Compares the field's value for all the records group and determines which record has the lowest value in the field. For example, if the fields in the group contain values of 10, 20, 30, and 100, the record with the field value 10 would be selected. This operation only works on numeric fields. If multiple records are tied for the longest value, one record is selected. Most Common Determines if the field value contains the value that occurs most frequently in this field among the records in the group. If two or more values are most common, no action is taken. Not Equal Determines if the field value is not the same as the value specified. Specifies the type of value you want to compare to the field's value. One of the following: Note: This option is not available if you select the operator Highest, Lowest, or Longest. Data Quality Guide Field Choose this option if you want to compare another dataflow field's value to the field. String Choose this option if you want to compare the field to a specific value. 123
