Example of Virtually Joining Columns and Showing Row States

When row states change in one data table that has a virtually joined column, those row states can automatically show up in virtually joined columns in other linked data tables. Suppose that the main and auxiliary data tables have a subject ID column. The row states are changed in the data table that contains a Link ID property on the subject ID column. Then the row states are updated in the data table that contains virtually joined Link Reference columns. You can specify whether the Link Reference columns send (dispatch) row states to the other data tables or receive (accept) row states.

Select Help > Sample Data Library and open Nic Demographics.jmp, Nic Labs.jmp, and Nic Adverse Events.jmp.

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

In Nic Labs.jmp, select the Unique Subject Identifier column and select Cols > Column Info.

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.

In Nic Demographics.jmp, right-click the first row and select Hide and Exclude.

The first row contains data for Unique Subject Identifier 101001.

View Nic Labs.jmp to see the excluded rows for Unique Subject Identifier 101001.

Cautions:

•

Please be aware that a data table can have multiple columns that reference the same data table. If Row States Synchronization options are set for all columns, the row states are dispatched to or accepted from all columns. A different row state might be dispatched to or accepted from the same row of the referenced table. This means that different referencing columns can overwrite each other’s row states.

•

Working with row states in multiple tables with multiple columns can be complex and should be done with caution.

Notes:

•

Multiple columns in table A can link to table B. And Table B can itself have multiple columns that link to table C. The row states of all of the rows appear in the data tables that contain linked columns. For example, if row 1 is excluded in table A and row 1 is hidden in table B, the main data table will show the row as excluded and hidden.

•

If a data table is accepting a specific row state, avoid manually applying that row state in the table. Let the dispatching column control that row state.