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

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

TDK_Long — Thu, 30 Nov 2023 00:57:10 GMT

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.

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

txnelson — Thu, 30 Nov 2023 03:23:43 GMT

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]

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

TDK_Long — Thu, 30 Nov 2023 23:30:39 GMT

Thank you Jim.