Combining sets

You can combine the contents of two sets to isolate the records that you require. The resulting combination is placed into a new set.

About this task

For example you might have two sets, one called Prime Suspects and one set that comprises all the records that were added during a recent import session. You can easily discover which members of the Prime Suspects set were not added during the recent import.

Procedure

You can specify how the records in two sets are combined to form a new third set:

  1. In a list of sets, select two sets, right-click and select Combine.

  2. Select how to combine the sets from the list:

    Option

    Description

    Include all records from both sets

    Combine the full contents of the sets.

    Include all records from set A only

    Create a copy of set A.

    Include all records from set B only

    Create a copy of set B.

    Include records from set A that are not also in set B

    Create a subset of set A that excludes records that are also found in set B.

    Include records from set B that are not also in set A

    Create a subset of set B that excludes records that are also found in set A.

    Include records from set A and set B that are not also in both

    Create a set of the unique records in both sets.

    Include records that are only in both set A and set B

    Create a set of the common records between the sets.

    Note: The Venn diagram illustration of the selected criterion helps you visualize the results.

  3. Enter the set name in Set C.

  4. Click OK to create the set. You might be prompted to specify a category and access control for the set.