Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- How do I concatenate all open data tables

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jan 5, 2017 7:12 AM
(7071 views)

Hi all,

This is my first time posting here, I have a script where I automatically open "n" tabs from excel into tables (where "n" is any number from 4 to 25) and then concatenate them. As the number of tabs changes is there any way in which I can just concatenate all currently open data tables rather than having to input every table name?

Thanks,

Joe

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

I should have mentioned that you should test this option interactively first. That is, select Open and then select your Excel workbook. You should then enter the Excel Import Wizard where you will find the option (check box) for concatenation.

This way will verify that what you want to do is possible and, if so, you can copy the Source table script to begin your own script.

Learn it once, use it forever!

3 REPLIES 3

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How do I concatenate all open data tables

You can use the optional argument to the Open() function to have the tables concatenated for you. See the Scripting Guide for details (Help > Books > Scripting Guide).

Learn it once, use it forever!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

I should have mentioned that you should test this option interactively first. That is, select Open and then select your Excel workbook. You should then enter the Excel Import Wizard where you will find the option (check box) for concatenation.

This way will verify that what you want to do is possible and, if so, you can copy the Source table script to begin your own script.

Learn it once, use it forever!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How do I concatenate all open data tables

Thank you very much! This is perfect!