Choose Language Hide Translation Bar
Highlighted
FN
FN
Level IV

Virtual linking two tables via JSL scripting

I have one a table opened by the user.

 

After some python code I generate another table that ends:

  • having a subset of columns (keeping same column names)
  • sharing its time index (few rows might have been removed).

How can link these two tables via JSL?

 

The functionality I am after is to have something equivalent as if I did a subset in JMP.

 
// Start of script;
Names Default To Here( 1 );
Clear Log();

dt = Open( "$SAMPLE_DATA/Bands Data.JMP" );

dt  << Subset(
	Linked,
	Suppress formula evaluation( 0 ),
	Sampling Rate( 0.9 ),
	columns( :timestamp, :proof cut, :viscosity, :caliper, :ink temperature )
)

 

 

 

 

1 REPLY 1
Highlighted
Craige_Hales
Staff (Retired)

Re: Virtual linking two tables via JSL scripting

The scripting index has three examples under Virtual Join.

Virtual Join in the Scripting Intex. Notice the Example 1 button is a pull down menu with other examples.Virtual Join in the Scripting Intex. Notice the Example 1 button is a pull down menu with other examples.

There's an example of virtual join in Reverse Geocode Lat-Lon to Zip . It saves the tables to disk before using

	zipcodeNS:dtdbf:shape << Set Property( "Link ID", 1 );
	zipcodeNS:dtshp:shape << Set Property( "Link Reference", Reference Table( zipcodeNS:dtdbf ) );

to link them by the shape property.

 

Craige
Article Labels