Essentials to understanding Virtual Join in JMP

Dahlia_Watkins · 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!

Ressel · ‎10-04-2023

@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!

Dahlia_Watkins · ‎10-04-2023

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