cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
TDK_Long
Level III

How to access one of the multiple data tables opened at the same time?

Hi folks,

 

I opened a couple data table by the following jsl,

 

dt = Multiple File Import();

 

After that, I tried to access one of the data table to process the data, what is the jsl script or command to access the the data table.

 

For example, if I need to access the 2nd data table row #2 and column #1, i used the command below:

 

dt[2][2,1]

 

but it did not work, please advise it, thanks.

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: How to access one of the multiple data tables opened at the same time?

The following code works on JMP 16 and 17

names default to here( 1 );
dt=
Multiple File Import(
	<<Set Folder( "<path to folder>"),
	<<Set Name Filter( "*.xls" ),
	<<Set Name Enable( 1 )
) << import data ;

dt[1][2,1]
Jim

View solution in original post

2 REPLIES 2
txnelson
Super User

Re: How to access one of the multiple data tables opened at the same time?

The following code works on JMP 16 and 17

names default to here( 1 );
dt=
Multiple File Import(
	<<Set Folder( "<path to folder>"),
	<<Set Name Filter( "*.xls" ),
	<<Set Name Enable( 1 )
) << import data ;

dt[1][2,1]
Jim
TDK_Long
Level III

Re: How to access one of the multiple data tables opened at the same time?

Thank you Jim.