User Community
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: 
  • Instantly extract effect sizes, F-ratios, and FDR-adjusted p-values from your models with the Calculate Effects Sizes extension, available now in the JMP Marketplace!
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • See how to use the JMP Marketplace – Free tools to expand JMP capabilities. Register. July 10, 2 pm US Eastern Time.

JMPer Cable

A technical blog for JMP users of all levels, full of how-to's, tips and tricks, and detailed information on JMP features
Choose Language Hide Translation Bar
Dahlia_Watkins
Staff Dahlia_Watkins
Staff
Essentials to understanding Virtual Join in JMP
Created: Oct 10, 2017 11:11 AM

Virtual Join links a main data table to one or more auxiliary data tables. This feature enables the main data table to access data from the auxiliary data tables without physically joining the tables. This video is an introduction to the basic concepts of Virtual Join in JMP. It will show you how to avoid common errors when joining your data. And it should help you understand how to achieve Virtual Joins with your data. 

(view in My Videos)
Let me know if you have any questions!

Last Modified: Oct 10, 2017 12:37 AM
Comments
Ressel
Level VII
‎10-04-2023 04:58 AM
‎10-04-2023 04:58 AM

@Dahlia_Watkins, what are some typical use cases of a virtual join? (I've been to a JMP user meeting once and someone dropped "And you've got virtual join [in JMP]!" into the conversation. I still don't know what to do with this information.) Thanks!

0 Kudos
Dahlia_Watkins
Staff
Staff
‎10-04-2023 09:23 AM
‎10-04-2023 09:23 AM

@Ressel, Virtual Join use cases may apply more to situations where a user wants to join a set of tables without creating a new table. Say you have three tables open that you want to join. Before Virtual Joins, joining the three requires a fourth table to be created using more of your system's memory. With Virtual Joins this is not the case. The tables are linked to a main data table, i.e. table 1 or table 2 of the three. With this link to the original three tables your machine resources remain free and your join is still accomplished. So the use case typically comes down to saving memory by not needing a fourth table to create the join.  

 

There are some additional advantages to Virtual Joins that are discussed in https://community.jmp.com/t5/JMP-On-Air/Virtual-Joins/ta-p/266958.

It includes some additional features added to Virtual Joins that were not included in Virtual Joins at the time I created this video.