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
- :
- Including all rows when splitting

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

Aug 24, 2017 8:44 AM
(381 views)

I have a dataset where class is broken into "Initial" and "Refined" groups. There are also subclasses within each group...

I want to split the table so the two groups are in two different columns like so

However, when I tried splitting the table as shown below I only get one instance of each Item Class.

Question: How can I split this table so that all values are represented?

3 REPLIES

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

Aug 25, 2017 8:55 AM
(357 views)

You can do it by adding a new Grouping column, which allows the matching of the Subclass levels(number). I just added a new column "Column 4" and gave it the formula:

`Right(:Subclass, 1)`

I then used it in the Tables==>Split platform

and got the results data table

Jim

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

Aug 28, 2017 11:44 AM
(251 views)

Thanks so much for your response Jim.

Unfortunately this workaround won't get what I need. There are 5000+ rows in the dataset and the Subclasses are all characters (the numbers I included were as an example only).

I might be able to fenagle an index column to achieve your example below but I was hoping I was just overlooking a box that needed to be checked.

My JSL writing skills are limited so don't waste your time coming up with a lengthy code snippit as a solution :)

Thanks again.

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

Aug 28, 2017 12:02 PM
(247 views)

I assumed the Right() function would not be the miracle cure for your problem. The point of the extra column is simply to just come up with a column that allows for the grouping requried for your data. If you think in those terms, you may find a simple solution in your data.

Jim