MAILERS+4:FAQ:Duplicate Check: Difference between revisions
Created page with "{{CustomTOC}} ==Key Field” Option== ===What is the “Key Field” option when checking for duplicates?=== Any field in your list can be formatted as a key field and Duplic..." |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
[[MAILERS+4:FAQ|← MAILERS+4 FAQ]] | |||
{{CustomTOC}} | {{CustomTOC}} | ||
| Line 28: | Line 29: | ||
[[Category:FAQ]] | [[Category:FAQ]] | ||
[[Category:Software]] | [[Category:Software]] | ||
[[Category: | [[Category:MAILERS+4]] | ||
[[Category:Reference]] | [[Category:Reference]] | ||
Latest revision as of 00:16, 6 January 2015
Key Field” Option
What is the “Key Field” option when checking for duplicates?
Any field in your list can be formatted as a key field and Duplicate Check will use it to find exact matches. Typical uses for the Key Field are customer number, reference number or even a company name. If you format the company field as your key field, Duplicate Check will tag duplicate records by finding records with company fields that exactly match your key field.
Keep Record Lowest, Highest Option
What is the “Keep Record Lowest, Highest option?
- Lowest
- Among a set of duplicate records, Duplicate Check will keep the record with the lowest record number and tag the rest as duplicates.
- Highest
- Among a set of duplicate records, Duplicate Check will keep the record with the highest record number and tag the rest as duplicates.
Number of Lists Run at Once
How many lists can I check for duplicates at one time?
With the Multiple Lists function it is possible to compare up to 15 lists at one time when checking for duplicates. Any duplicate records shared among lists can then be marked for deletion and removed using the Pack feature under the Database menu.
Removing Duplicates
After running Duplicate Check how do I remove the duplicates from my list?
When at the Duplicate Check options screen you will see an option of "Mark Duplicates for Deletion". Duplicate Check will automatically mark for deletion all dBase records it tags as duplicates. After the Duplicate Check is done go to the Pack feature under the Database menu and click on the Pack command.