Using JMP • Reshape Data • Virtually Join Data Tables • Example of Merging Referenced Data in Virtually Joined Data Tables

For the latest version of JMP Help, visit JMP.com/help.

Previous
 • 
Next
Example of Merging Referenced Data in Virtually Joined Data Tables
To share the data from virtually joined data tables with another user, you might want to merge the data so that the data tables are permanently joined. This option is helpful because you provide one data table, not the main and auxiliary data tables.
When you merge referenced data, the data are replicated from the auxiliary data table to the main data table. When you save the main data table, the actual data are also saved.
1.
Select Help > Sample Data Library and open Pizza Profiles.jmp and Pizza Responses.jmp.
2.
Right-click the ID column in Pizza Profiles.jmp and select Link ID.
3.
Right-click and select Link Reference > Pizza Profiles.jmp.
The selected column is linked to the ID column in Pizza Profiles.jmp.
Figure 6.40 Selected Column in Virtually Joined Data Table
4.
In Pizza Responses.jmp, select Choice1.
Note: If you do not select the columns, then all columns will be in the merged data.
5.
From the data table’s red triangle menu, select Merge Referenced Data.
Figure 6.41 Merging Referenced Data
A message confirms that the selected column was merged. Notice that the virtual join icon for Choice1 no longer appears in the Column list. The Link Reference column property was removed.
Figure 6.42 Merged Data

Previous
 • 
Next
Help created on 3/19/2020