cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.
Choose Language Hide Translation Bar
Comparing Data Tables - New in JMP 16
Created: May 3, 2021 09:03 AM  |  Last Modified: Apr 8, 2025 6:24 AM

Beginning with JMP 16, JMP offers the ability to interactively compare data tables by comparing columns with different names showing the results in a table.

Highlights

  • Compare Data Tables utility has a more flexible interface with increased functionality to align rows with a key rather than automatically matching rows and compare columns with different names.
  • Comparison results are shown as a table.
  • Added the ability to align rows with a key rather than automatically matching rows.
  • Added the ability to compare columns with different names.
  • Results are shown as a table.

To compare tables:

  1. Open two or more data tables.
  2. From the Tables menu in either table, select Compare Data Tables
  3. Leave (or change) defaults.  In this case, under how to Align Data, leave Flexible by Row.
  4. Click Compare.
    1. Examine  Summary table view of the Compare results in each cell. For example, in row 3 of both tables, the Nonstudents cell data differed, with the difference being 6 to 3.
    2. Select a cell to examine the table cell differences.

Resources

Compare Data TablesCompare Data Tables Compare Data Tables

Recommended Articles