cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar

Any way to close all tables EXCEPT the table of interest?

Hi Guys,

Is there any way to close all the tables open in the JMP except the table of interest?

I tried using the close all(Data tables) command and it closes all of them. Also I don't want to individually close every table because I have several tables open.

Thanks.
1 ACCEPTED SOLUTION

Accepted Solutions
nacka
Level II

Re: Any way to close all tables EXCEPT the table of interest?

Here's a function that will do exactly what mpb says (and it works):

 

CloseAllDataTablesExcept = Function({FunctionDataTable},
	FunctionName = FunctionDataTable << Get Name;
	For(i=NTable(), i>0, i--,
		If(DataTable(i)<<GetName != FunctionName,
			Close(DataTable(i), nosave)
		)
	);
);

View solution in original post

4 REPLIES 4
mpb
mpb
Level VII

Re: Any way to close all tables EXCEPT the table of interest?

You can go through each open table using a For loop from N Table()to 1, looking at Data Table(i) << Get Name, to compare each name to the one you want to keep open. Either leave it open if it's the keeper, or close it without saving if it's not. You need to go backwards in the loop because of the way JMP numbers the tables. Let me know if I've got that mixed up ... the idea is sound though.
nacka
Level II

Re: Any way to close all tables EXCEPT the table of interest?

Here's a function that will do exactly what mpb says (and it works):

 

CloseAllDataTablesExcept = Function({FunctionDataTable},
	FunctionName = FunctionDataTable << Get Name;
	For(i=NTable(), i>0, i--,
		If(DataTable(i)<<GetName != FunctionName,
			Close(DataTable(i), nosave)
		)
	);
);
uday_guntupalli
Level VIII

Re: Any way to close all tables EXCEPT the table of interest?

DontClose = {"Test1", "Result"};   // Example names of tables you want to leave

// Loop backwards through the list, so the table numbers do not change
For( i = N Table(), i >= 0, i--, 
	If( Contains( DontClose, Data Table( i ) << get name ),
		Continue(),
		Close( Data Table( i ), "No Save" )
	)
);

 https://community.jmp.com/t5/Discussions/JSL-How-to-close-data-tables-after-analysis/m-p/36739#M2164...

Exact same question . Another way to script it . The post above also addresses this question 

Best
Uday
Roselle_Grant
Level II

Re: Any way to close all tables EXCEPT the table of interest?

Worked like a charm!