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 split a big data table into smaller ones? (un-merge or opposite of conc...

Topic Options

- 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
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Apr 30, 2017 4:29 PM
(3413 views)

Hi,

Is there a script or a function which would essentially do the opposite of the "Concatenate" function? I have a massive data file with a source column which is the primary key & other columns associated with each primary key. I am trying to split this massive data table into several smaller tables based on the primary key.

Any suggestions?

Thanks

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

The easiest way to do this is to use the Subset with the "Subset By" selection

Talbles==>Subset

Jim

3 REPLIES 3

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

The easiest way to do this is to use the Subset with the "Subset By" selection

Talbles==>Subset

Jim

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

Re: How do I split a big data table into smaller ones? (un-merge or opposite of concatenate)

I tried it and it worked perfectly. Thanks a bunch!

I must confess I am bit embarrassed that for as long as I have been using JMP (especially the "Subset" function) I did not even notice the "By" checkbox.

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

Re: How do I split a big data table into smaller ones? (un-merge or opposite of concatenate)

I remember using JMP 3, and with the breadth and depth of JMP, I learn new JMP functionality all the time.

Jim