Data comparator: family comparisons

In some cases, you may need to compare grid entries not individually among each other, but as "groups" of entries.

In the data comparator, these groups are called 'Families'. The entries contained within a Family are called 'Members'.

The comparator allows you to set the criteria that determines the makeup of these Families, as well as what identifies their individual Members.

These individual Members can then be compared against the corresponding Members of other data Families in order to:

In the fictional example above, a database of vital information is the subject of a comparison where the user wants to compare, among real-life families, to see if all members of each family have been vaccinated, have medical insurance, and what medication they take.

Master References in Family Comparisons

When doing a family comparison, the master reference section differs slightly from that of a basic comparison.

The following options are available:

The above comparison has been grouped by the column 'SurName' to better illustrate what has been compared.

The presence of the Members, defined by the values of the 'ROLE' column, is checked among all other Family Sets. The following results are shown:

The columns that have been chosen to have their values compared are 'IS_VACCINATED', 'HAS_MEDICALINSURANCE', and 'Meds'. The results are displayed as in any basic comparison.

However, for the Members that were found to be Missing, or for Members that were Extraneous, since no comparison was possible, they are marked as Not Compared.

Additional Family Comparison Options

The option 'Check presence of the Family Members ONLY' limits the comparison to checking if all data Family Members are found among the other Family Sets.

In these types of comparisons the master reference selection grid is disabled. No column selection is required in the top window of the Comparison Setup dialog.

For more details about the options 'Compare displayed values, not actual values' and 'Add detailed description in Results Columns' can be found in the Basic Comparator Overview.

Selecting Multiple Family/Member Columns

Members

Sometimes it is necessary to select a more specific set of properties to determine individual Members of data Families.

In these cases, you may select more than one column to define Members.

Here, the additional column of 'EYECOLOR' has been added to 'ROLE' to help further define the Members of the Family Set.

Families

When comparing Family Sets, selecting multiple columns will increase the precision of your data Family criteria (as with Members). When the option 'Add detailed descriptions in Results Columns' is used in tandem with multiple Family column selections, it will provide a more thorough description in your Results Column text.

In the example above, the data Families will be defined by the columns (properties) 'Database Path' and 'Database File'. The options 'Add detailed descriptions in Results Columns' and 'Compare displayed values not actual values' have been checked.

The option 'Add detailed descriptions in Results Columns' (verbose descriptions) has been checked, and we can see that the order of the properties 'Database Path' and 'Database File' has been respected in the cell text.You can change the order of these properties in the middle window using the up/down arrow keys.

This will not affect the comparison results themselves, but only the format of the text in the detailed Results Column descriptions.

After having changed the order of the column names, the Results Column text has changed accordingly.