- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Pivot Table
Hi,
I like to transform the following attached JMP table (sample) into sample_out.
I appreciate your help. Thanks
2 ACCEPTED SOLUTIONS
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Pivot Table
Hi @AT ,
One option for accomplishing what you want is to use one of the table functions, specifically, Tables-->SplitTables-->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
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Pivot Table
Thanks so much for quick response. I did try it and works as expected.
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Pivot Table
Hi @AT ,
One option for accomplishing what you want is to use one of the table functions, specifically, Tables-->SplitTables-->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
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Pivot Table
Thanks so much for quick response. I did try it and works as expected.