BookmarkSubscribe
gail_massari
Community Manager Community Manager

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 @olippincott 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.

 

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

Joined Table.JPGResults 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.

 

Link Id for Virtual Join.JPGCreating Link ID in auxiliary (referenced) table column while setting up virtual join.

 

Link Reference in Auxiliary Table.JPGCreating Link Reference in main table column while setting up virtual join.

 

alertt if you try to make Link ID a column that does not have unique values.JPGJMP alerts you if you choose a Link ID column that does not have unique values.

 

analyzing virtually joined data.JPGAnalyzing virtually joined tables using JMP.

Comments
andersonmj2

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!

Article Labels
Article Tags