Compare Metadata

The Compare tab in Metadata identifies differences in metadata between studies for selected domains. By default, schemas or studies and their associated data marts display with no selections made. Staging Areas can also be displayed and selected. Select the schemas to include in the comparison. If a schema includes multiple data marts or staging areas, each displays under the study. Select the data marts or staging areas to compare.

1. Within Metadata, click the Compare tab.
   
2. Click to show Data Marts and / or Staging Areas. Data Marts is checked by default, select Staging Areas if appropriate.
3. Under Schemas, select the schemas to compare.
   1. Use the Search field to narrow results; as text is entered, the list updates accordingly.
   2. Check Select All to include all schemas.
   3. Select individual schemas by checking the box to the left of each name. Use the scrollbar to see all listed schemas. As Schemas are selected, the associated Domains populate the panel to the right.
4. Under Domains, select the domains to compare.
   1. Use the Search field to narrow results; as text is entered, the list updates accordingly.
   2. Check Select All to include all domains.
   3. Select individual domains by checking the box to the left of each domain. Use the scrollbar to see all listed domains.
5. The compare results are displayed in the main window, sorted by Domain. 
   1. Use the Previous Page / Next Page icons in the master header to navigate the list.
   2. By default, 20 Rows display per page. Click the down arrow to update the number of rows in a page (10, 50, or 100). 
6. Click the drop-down arrow next to Compare By to select Variable Names (default), Variable Labels, Data Types, or Length/Precision. Results are color coded, making it easy to identify the discrepancies. In the example below the Compare by Length/Precision was selected to compare the AE domain for studies Clintek_007, Clintek_010, and Clintek_011.
   
   
    

By default, all three filter buttons are highlighted with solid icons, so the comparison results display rows with discrepancies, partial matches, and identical entries.

Click any of the filter buttons to deselect them. For example, to view only discrepancies, deselect the No Discrepancies and Partially Identical buttons.

• No Discrepancies: No highlight, there are no differences.
• Partially Identical: Yellow highlight, one schema may not have the variable as in another schema, so it is not wrong, but it is not identical.
• Discrepancies: Red highlight, there are differences in the variables across the schemas.

Export Compare Results

The Compare results can be exported to Excel using the Export button in the master header. Color coding / highlighting persists to the export.