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
- :
- Discussions
- :
- Concatenating two databases from the same Excel Spreadsheet

Topic Options

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

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

Concatenating two databases from the same Excel Spreadsheet

Dec 2, 2009 8:42 AM
(1255 views)

Hello all,

I tried concatenating two databases from the same excel spreadsheet multiple times, but was unable to do so. Does anyone have any suggestions?

I tried concatenating two databases from the same excel spreadsheet multiple times, but was unable to do so. Does anyone have any suggestions?

5 REPLIES 5

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

Re: Concatenating two databases from the same Excel Spreadsheet

Are you trying to do the concatenation via scripting? Or are you having trouble concatenating them even manually through the table menu?

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

Re: Concatenating two databases from the same Excel Spreadsheet

Via scripting, I can see easily enough how to do it manually, but writing a script has eluded me.

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

Re: Concatenating two databases from the same Excel Spreadsheet

Here's a rough starting example which assumes the user selects exactly 2 sheets from the .xls file.

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

Re: Concatenating two databases from the same Excel Spreadsheet

I was reminded of the fact that Data Table(1) corresponds to the most recent data table, Data Table(2) to the next most recent and so on. This makes my previously posted snippet work correctly only if there are no other open tables when it is run. Here is one that should work correctly even if there are other tables open. It still requires work to make it robust to other possibilities.

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

Re: Concatenating two databases from the same Excel Spreadsheet

Thank you very much for the reply! As soon as I have a chance to try this out, I will, and I'll let you know how it works for me.