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
- :
- Re: Pivot Table

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

Jan 30, 2019 11:02 AM
(473 views)

Hi,

I like to transform the following attached JMP table (sample) into sample_out.

I appreciate your help. Thanks

2 ACCEPTED SOLUTIONS

Accepted Solutions

Highlighted
Solution

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

Hi @AT ,

One option for accomplishing what you want is to use one of the table functions, specifically, Tables-->Split

And the resulting JSL script--

```
Data Table( "sample.jmp" ) << Split(
Split By( :test_parameter ),
Split( :value ),
Sort by Column Property
)
```

cheers,

Stan

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

Thanks so much for quick response. I did try it and works as expected.

2 REPLIES 2

Highlighted
Solution

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

Hi @AT ,

One option for accomplishing what you want is to use one of the table functions, specifically, Tables-->Split

And the resulting JSL script--

```
Data Table( "sample.jmp" ) << Split(
Split By( :test_parameter ),
Split( :value ),
Sort by Column Property
)
```

cheers,

Stan

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

Thanks so much for quick response. I did try it and works as expected.