Fuzzy Match columns must meet a similarity threshold. Exact match columns must be matched exactly to be considered matches. The match type for paired fields can be set to either Exact Match, the generic Fuzzy Match, or a more specific match type. The component treats 0 as False and 1 as True. True/False and Yes/No strings are supported. The component attempts to parse the string to a boolean. Internally numbers are converted to a common compatible type and compared. The component supports the following comparisons of different data types:

Note: Fields that are different types can be compared, but a warning may be shown if the comparison combination is unsupported. Key fields must be the same value and the same type to be considered equal. For example, when comparing a decimal number, 5.00 and an integer value 5 the values will be considered equal. When fields of different types are compared, the component attempts to convert them to a common type, and compare them. The composite business key is used to determine which rows to compare in the old data input and new data input. A composite business key is created from all the business key fields that are selected, and the composite key must be unique within each input. For every field that has been paired it is possible to designate the field as a business key. Each of these fields can be paired to a field in the new data input. The Fields To Compare grid will display all the available fields from the old data input. The General page of the Diff Detector Component allows you to specify the general settings of the component. The component includes the following three pages to configure how you want to read data. New data input rows that did not have a matching key in the old data input. Old data input rows that did not have a matching key in the new data input. Old data input rows that match all the compared fields of new data input rows that they were compared to.Ī combination of old data input rows and new data input rows that had matching business keys, but did not match on all the compared fields.

Mailchimp duplicate detector