De-duplicating sample (AskiaLister)

AskiaLister allows you to de-duplicate the currently open sample file. You can search for duplicate records based on the contents of any field (or combination of fields), and then easily delete the duplicate records, either manually, or by automatically keeping the first or last of any set of duplicates.

To de-duplicate sample:

  1. Open the sample list which you want to de-duplicate (to open a list, select open from the file menu).

  2. In the tools menu, select view duplicates. The search duplicate records dialog appears.

  3. In the field list, select the appropriate fields. AskiaLister will find any records which have identical values in this field. For example, if you want to search for fields with duplicate email addresses, select the email field (the name of the field will depend on your particular list file).
    If you select multiple fields, AskiaLister will find duplicate records with identical values in all of the selected fields. For example, if you select first name, middle name, and last name, plus address fields, AskiaLister will consider any people with the same first, middle and last names, and also with the same address, to be duplicate records.

  4. If you want to view Askia's hidden fields, select display the system fields. By default, these are selected. You can then, if you wish, use these as fields in your search.

  5. Click search. The duplicate records are displayed in the right-hand pane, according to the fields you selected in the previous step. AskiaLister may find more than two records that are considered duplicates, if more than two share the same values in the selected fields. To view the contents of Askia's hidden fields in this pane, select display the system fields.

  6. To manually delete a record, simply right-click it and select remove.

  7. To automatically delete duplicate records, select keep the first item or keep the last item (see below), and click remove duplicate items. If you selected keep the first item, then for each group of records considered to be duplicates, all will be deleted except for the first one. If you selected keep the last item, all will be deleted in each group except for the last one.

  8. When you have finished removing duplicate records, click close.

Create your own Knowledge Base