cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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.

Recommended Articles