Using JMP > Enter and Edit Data > Organize Data > Compare Data Tables
Publication date: 08/13/2020

Compare Data Tables

JMP can compare two open data tables and report the differences between data, scripts, table variables, column names, column properties, and column attributes. Character values that do not match exactly appear in the report. For numeric data, you can select a relative (or fuzzy) comparison. The numeric values are considered equal if they are within the relative error rate that you specify. The smaller the relative error, the more precise the comparison.

To compare two data tables

1. Open the data tables.

2. In one of the tables, select Tables > Compare Data Tables.

3. If necessary, select the data table that you want to compare from the list.

4. (Optional) Select Fuzzy Compare and enter the relative error to see numeric differences within the specified rate.

5. Click the red triangle and select the following options:

which items you want to compare

how to show the differences

6. Click Compare.

The Difference Summary and Difference Plot are shown by default. The red triangle options that you selected also appear.

Basic Table Information

The Tables Info report shows the data table names and locations along with the numbers of columns and rows in each table. In Figure 4.22, you see that Big contains one more row than Big

Figure 4.22 Basic Information 

Compare Data

The interactive Difference Summary report and Different Plot indicate how rows differ between reports. Each entry in the Difference Summary report shows which action occurred, how many rows are affected, and the first row in which the change occurs.

In Figure 4.23, Big (left) and Big (right) are compared.

The first entry in Figure 4.23 indicates that one row (N) has changed (or been replaced) in the first row of Big When you select the entry in the Difference Summary report on the left, the entry is highlighted in yellow, and the row flashes in the data table.

For a graphical view of the comparison, place your cursor over a colored cell in the Difference Plot. Figure 4.23 shows that the name KATIE in Big was changed to KIM in Big The entire first row is highlighted in the Difference Plot, which tells you that all values in that row are different.

Figure 4.23 Modified Data 

In Figure 4.24, the second entry indicates that two rows were deleted beginning at row four. The deleted rows are highlighted in Big on the left. And the Difference Plot specifies the different values. The name in row four of Big was JACLYN and TIM in Big

Figure 4.24 Deleted Rows 

In Figure 4.25, the third entry tells you that one row was added before what was originally row eight. The name in row eight of Big was ROBERT. PETER is the name in row six of Big

Figure 4.25 Identify New Rows 

Click the Previous difference and Next difference buttons above the Difference Summary to navigate from row to row.

Tip: Save the Difference Summary report to a data table by selecting Save Difference Summary from the red triangle menu.

Compare Table Properties

Click the red triangle and select Compare Table Properties to see differences in table scripts and variables. For example, Figure 4.26 shows that the Distribution script in Big refers to the height column rather than the weight column.

Figure 4.26 Modified Table Script 

Compare Column Attributes and Properties

Click the red triangle and select Compare Column Attributes and Properties to see differences in column notes, cell colors, and the like. For example, Figure 4.27 shows that column notes and value colors differ between Big and Big

Figure 4.27 Modified Column Attributes and Properties 

Want more information? Have questions? Get answers in the JMP User Community (