BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
AT

Community Trekker

Joined:

Dec 2, 2017

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
stan_koprowski

Community Manager

Joined:

Aug 8, 2012

Solution

Re: Pivot Table

Hi @AT ,

One option for accomplishing what you want is to use one of the table functions, specifically, Tables-->SplitScreenshot 2019-01-30 14.08.42.pngTables-->Split

And the resulting JSL script--

 

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

cheers,

Stan

 

Highlighted
AT

Community Trekker

Joined:

Dec 2, 2017

Solution

Re: Pivot Table

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

2 REPLIES 2
stan_koprowski

Community Manager

Joined:

Aug 8, 2012

Solution

Re: Pivot Table

Hi @AT ,

One option for accomplishing what you want is to use one of the table functions, specifically, Tables-->SplitScreenshot 2019-01-30 14.08.42.pngTables-->Split

And the resulting JSL script--

 

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

cheers,

Stan

 

Highlighted
AT

Community Trekker

Joined:

Dec 2, 2017

Solution

Re: Pivot Table

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