cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
How do you physically and virtually join multiple tables in JMP?

JMP lets you physically join data from up to 60 tables.  Or, to save memory and space, you can link (virtually join) a main JMP data table to one or more updatable auxiliary data tables without physically joining the tables.

 

Systems Engineer Olivia Lippincott @O_Lippincott demonstrates how.

 

 

Physically Joining Tables

After importing data into JMP, you can join any two tables based on a common column. JMP lets you choose the columns interactively. The columns do not need to have the same name. And, you can interactively filter column values to import/join only selected column values into the JMP table.

 

In the first part of this demo, Olivia imports data from different sources (Internet, database, Excel) and then joins them, showing how you can selectively filter and import only selected values (in this case, females) for a particular column.

 

JMP lets you interactively filter and select specific values to import into the joined table.JMP lets you interactively filter and select specific values to import into the joined table..

Results of final physical join into one JMP table.Results of final physical join into one JMP table.

Virtually Joining Tables

Virtually joining tables saves memory, because the same data are not replicated in every table that references them. Linked data can be independently updated in the main JMP table without being updated in the auxiliary (referencing) table. As when physically joining tables, tables are joined by common columns. The columns must have unique IDs. If they don't, JMP will alter you so that you can correct the problem.

 

In the second part of this demo, Olivia creates a Link ID and a Link Reference. The  Link ID column in the auxiliary (referencing) table will match the Link Reference column in the main JMP table. She performs an analysis in the virtually joined data. The next time she opens the main table, if the auxiliary data table has been updated, her analysis will use the new data.

 

Creating Link ID in auxiliary (referenced) table column while setting up virtual join.Creating Link ID in auxiliary (referenced) table column while setting up virtual join.

 

Creating Link Reference in main table column while setting up virtual join.Creating Link Reference in main table column while setting up virtual join.

 

JMP alerts you if you choose a  Link ID column that does not have unique values.JMP alerts you if you choose a Link ID column that does not have unique values.

 

Analyzing virtually joined tables using JMP.Analyzing virtually joined tables using JMP.

Comments

Virtual joins in JMP have changed my life! :)  The ability to have a technician generate a 'key map' table with simplified A-Z conditions and columns for each experimental parameter ... then just have a 'condition' column in all of our measurement files and then do a virtual join?  Incredibly efficient!

Recommended Articles