Subscribe Bookmark RSS Feed

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.


Super User


Jun 23, 2011

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.

Community Trekker


Aug 4, 2016

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)

Community Trekker


Sep 15, 2014

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 ),
		Close( Data Table( i ), "No Save" )

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