User Community Service Desk Downloads
If you can't find the product or version you're looking for, visit

Comparing Records

When you need to analyze several records and make more informed decisions on merging and splitting, you can compare them side by side and inspect their differences, including their instance records and related child records.

Search and select records

MDM Web App lets you compare any records within the same entity. You can also compare related records and instances from the record detail.

From the entity

To compare records from an entity:

  1. Search for records and select those you want to compare.

    Press and hold Shift to select multiple consecutive records. Ctrl and select will add records to your selection.
  2. From the upper-right search results menu, select Compare.

From the record detail

To compare in this way, open a record detail.

  1. Select two or more records you wish to compare.

  2. In the upper-right corner of the table, select Compare.

Compare button in record detail

Compare records

When comparing records, the attribute values that are not the same for all records are displayed in bold type.

To see related child entity records (including direct instance records when master records are compared), select one of the entities in the Related entities section.

To help you easily identify which related record belongs to which compared record:

  • The records are coded using colors and numbers.

  • Groups of related records are separated by colored lines.

When only one master record is open in the compare view, the Horizontal compare view is used by default. When comparing 2-8 records, the Vertical compare view opens as the default.

If more than eight records are selected, the Horizontal compare view opens as the default. You can switch between the vertical and horizontal layout using the three-line icon in the upper-right corner.

When you add or remove a record, the layout does not change automatically.

Vertical compare can be disabled, or the default vertical compare record threshold can be edited, using the GUI configuration in ONE Desktop.

You can drag and drop to reorder columns when comparing, as well as select which columns you would like to see. Use the Column Setup button (a gear on vertical lines icon) in the upper-right corner while in Compare View.

Column setup in compare view
The Drag and drop functionality is not available when a query is entered in the search bar.

Vertical compare

Use Show differences to filter only the attributes that differ between the selected records.

When comparing records in vertical view, authored records can be identified by the Authored record indicator (a user with a padlock icon).

To choose additional records for comparison, select Add records.

Vertical compare view tab

Horizontal compare

Horizontal compare view tab

Merge master records

After comparing the selected master records, you might find it necessary to manually merge the master records into one. For more information and detailed instructions about merging master records from both vertical compare and horizontal compare, see Merging and Splitting Records, section Merge master records.

Split and merge instances

When comparing master records and their instance records, it might become necessary to manually split or merge the instance records. For more information about splitting and merging instance records, see Merging and Splitting Records, section Split and merge instance records.

Was this page useful?