You can combine the contents of two sets to isolate the records that you require. The resulting combination is placed into a new set.
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.
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.