topic Re: How to delete/close all data table with non zero rows from workspace at once? in Discussions

How to delete/close all data table with zero rows from workspace all at once?

Souvik — Sun, 11 Jun 2023 11:50:05 GMT

Re: How to delete/close all data table with non zero rows from workspace at once?

David_Burnham — Thu, 12 Sep 2019 22:32:09 GMT

Does that mean you want to keep tables open if they have zero rows? Not sure how to do that without a script, but generally if I want to close all my tables then I go to one of my tables and from the menu select Window>Close All Data Tables.

Re: How to delete/close all data table with non zero rows from workspace at once?

Souvik — Thu, 12 Sep 2019 22:57:33 GMT

Hello David, sorry there was a typo in the question, I want to delete/remove all the tables that are there in my workspace which has zero rows; I mean close all the empty tables at once.

Actually I have developed a script which is generating about 100 tables and some tables (about 30 suppose) will not contain any data hence empty. I want to remove those tables from workspace in order to make it look clean and also easy to navigate between tables.

I would like to know if any jsl command is there to do the operation ?

Re: How to delete/close all data table with non zero rows from workspace at once?

txnelson — Fri, 13 Sep 2019 00:42:12 GMT

There exist multiple previous discussions on this. But, here is a simple piece of code that will do what you want:

Names Default To Here( 1 );

For( i = N Table(), i >= 1, i--,
	If( N Rows( Data Table( i ) ) == 0,
		Close( Data Table( i ), nosave )
	)
);