1.
Select Help > Sample Data Library and open Nic Demographics.jmp, Nic Labs.jmp, and Nic Adverse Events.jmp.
2.
View Nic Labs.jmp.
Notice that, in the Columns list, the blue Virtual Join icon appears next to Unique Subject Identifier. The blue color indicates that the column has a Link Reference column property and the referenced data table (Nic Demographics.jmp) is open. The Link Reference column property links the Unique Subject Identifier column in the current data table to the Unique Subject Identifier column in the referenced data table. If the icon is gray , the referenced data table is not open, or the columns could be linked incorrectly.
Nic Adverse Events.jmp is set up the same way.
Figure 5.39 Link Reference Column Property on Unique Subject Identifier
3.
In Nic Labs.jmp, select the Unique Subject Identifier column and select Cols > Column Info.
4.
Select the Link Reference column property.
Notice that Accept is selected. This means that when rows in the referenced data table (Nic Demographics.jmp) contain a row state, the row state automatically appears in the current data table.
Also notice that the Select, Exclude, and Hide row states are selected. When these row states are selected in Nic Demographics.jmp, the row states will appear in Nic Lib.jmp and Nic Adverse Events.jmp.
5.
In Nic Demographics.jmp, right-click the first row and select Hide and Exclude.
6.
View Nic Labs.jmp to see the excluded rows for Unique Subject Identifier 101001.
Cautions: 
Notes: 

Help created on 7/12/2018