This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
How do I split a big data table into smaller ones? (un-merge or opposite of concatenate)
Apr 30, 2017 07:29 PM(6510 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.
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.