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: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

JMP Tips

View Translated Thread
Virtually Join Data Tables
Created: Oct 11, 2023 04:33 PM  |  Last Modified: Feb 10, 2025 1:08 PM

If you want to merge related content in different data tables, save memory and time by joining them virtually. A virtual join links a main data table to one or more secondary data tables. The main table can then access data in the secondary tables without physically joining them.

To do a virtual join:

  1. Open the tables that you want to virtually join.
  2. In the secondary table that contains a unique identifier column to be linked to, right-click the column heading and select Link ID.
  3. In the main table that has values that reference unique key columns in the other table, right-click the column heading and select Link Reference, then select the table it links to.
  4. From the main data table, launch a platform. Referenced column groups appear in the launch window. Click a group to expand it, select columns, and run your analysis as usual.

Virtual JoinVirtual Join

0 Kudos