•
|
The Link Reference column property links a column in the main data table to the Link ID column in the referenced data table. The column property specifies the path name of the referenced data table. The column that has a link reference is referred to as the referencing column. The referencing column can look up the data of the auxiliary data tables through the Link ID column.
|
Figure 5.36 shows an example of virtually joined data tables. Pizza Profiles.jmp is the referenced data table because the ID column contains a Link ID column property. The ID column contains unique values that correspond to data in the referencing data table, Pizza Responses.jmp.
Figure 5.36 Virtually Joined Data Tables
Note: A column can have a Link Reference column property, but it does not necessarily have to link columns from the referenced data table. The virtual join icon next to the column in the Columns list is gray . This can happen if the referenced data table is not opened or the referencing column is excluded. See Virtual Join Icons in Get Started for details about the other virtual join icons.