This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
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: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
How do you join and virtually join tables in JMP?
Created: Jul 6, 2020 04:05 PM  |  Last Modified: Dec 3, 2021 04:16 PM

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.

 

gail_massari_0-1594065692698.jpeg

 

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

 

gail_massari_1-1594065692703.jpeg

 

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.

 

gail_massari_2-1594065692708.jpeg

 

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

 

gail_massari_3-1594065692710.jpeg

 

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

 

gail_massari_4-1594065692713.jpeg

 

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

 

gail_massari_5-1594065692715.jpeg

 

Analyzing virtually joined tables using JMP.

Comments
AU
‎02-25-2022 03:06 PM

Hello! I am having issues with importing from excel if excel is  using the =concat() function. How can cells using this function properly roll over to JMP during import?

gail_massari
‎02-28-2022 09:03 AM

Hi @AU .  It looks like you are using JSL to Excel data.  That makes your question more appropriate for the Discussion area, which is used by lots of JSL experts.  Consider also adding an example to a new post there. 

AU
‎02-28-2022 09:03 PM

Thanks @gail_massari .

Recommended Articles