Subscribe Bookmark RSS Feed

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

tejvishnu

Community Trekker

Joined:

Jul 1, 2016

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
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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

     Talbles==>Subset

subset by.PNG

 

Jim
3 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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

     Talbles==>Subset

subset by.PNG

 

Jim
tejvishnu

Community Trekker

Joined:

Jul 1, 2016

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. 

txnelson

Super User

Joined:

Jun 22, 2012

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

Jim