An example of Virtual Joins and Data Filters

[#1]

This script takes the guide example shown in this help guide on virtual joins and brings the tables together with a data filter to show how you can control data across multiple tables. This is intended as a quick guide and a way to 'play around' with virtual joins to get a feel of the tool.

Ran on JMP v18. 

nicdem=Open( "$SAMPLE_DATA/Nic Demographics.jmp" );
niclabs=Open( "$SAMPLE_DATA/Nic Labs.jmp");
nicad=Open( "$SAMPLE_DATA/Nic Adverse Events.jmp");

nicdem<<New script("Global Data Filter Example",Current Data Table() << Data Filter(
	Location( {146, 146} ),
	Global(1), //Included in case you have dashboards/windows that you want to communicate within tablesac
	Mode( Include( 1 ) ),
	Add Filter(
		columns( :Unique Subject Identifier ),
		Where( :Unique Subject Identifier == "11009" ),
		Display( :Unique Subject Identifier, N Items( 15 ), Find( Set Text( "" ) ) )
	)
););

nicdem<< bring window to front;