- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
How to delete/close all data table with zero rows from workspace all at once?
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to delete/close all data table with non zero rows from workspace at once?
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.
-Dave
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to delete/close all data table with non zero rows from workspace at once?
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 ?
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 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to delete/close all data table with non zero rows from workspace at once?
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 )
)
);
Jim