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.

Thanks.
3 REPLIES
mpb

Super User

Joined:

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.
nacka

Community Trekker

Joined:

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

Community Trekker

Joined:

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