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

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

Fri, 09 Apr 2010 15:50:26 GMT

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.

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

mpb — Fri, 09 Apr 2010 17:30:07 GMT

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.

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

nacka — Wed, 18 Oct 2017 12:21:44 GMT

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)
		)
	);
);

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

uday_guntupalli — Wed, 18 Oct 2017 21:29:30 GMT

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#M21649

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

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

Roselle_Grant — Fri, 17 Apr 2020 05:12:53 GMT

Worked like a charm!

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

hogi — Tue, 20 Jan 2026 21:26:18 GMT

via right click: