Has there been any work / tests done by yourselves or forum users to de-duplicate data.
So if I have a contact business object:
a) As data being entered (on save) certain values are checked to see if they already occur
b) Once there is data in place that a process could be done to identify duplicates
Data De-duplicate
-
- Posts: 595
- Joined: Sun Apr 24, 2005 2:22 am
- Contact:
a) You can add rules to the object to check for and reject duplicate attribute values. For example, you could add the following rule for object Contact. The rule will be checked when a new Contact is created (via form or otherwise) or an existing Contact is modified:
If EXISTS Contact WHERE (Contact.FirstName = ThisContact.FirstName AND Contact.LastName = ThisContact.LastName AND Contact.ID <> This Contact.ID) Then
REPORT ERROR 'Contact with this first and last name already exists.'
b) With necessary validation rules in place (as described above) the easiest way to avoid duplicates would be to import contact data from file into Aware IM with the Validate Data option enabled. Any duplicate records (according to the rules) will be rejected. The rejected entries will be noted in the import log. You can check the import log and make corrections as necessary.
If EXISTS Contact WHERE (Contact.FirstName = ThisContact.FirstName AND Contact.LastName = ThisContact.LastName AND Contact.ID <> This Contact.ID) Then
REPORT ERROR 'Contact with this first and last name already exists.'
b) With necessary validation rules in place (as described above) the easiest way to avoid duplicates would be to import contact data from file into Aware IM with the Validate Data option enabled. Any duplicate records (according to the rules) will be rejected. The rejected entries will be noted in the import log. You can check the import log and make corrections as necessary.
Aware IM Support Team