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:
-
In a list of sets, select two sets, right-click and select
Combine.
-
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.
-
Enter the set name in Set C.
-
Click OK to create the set. You might be prompted to specify a category
and access control for the set.
