BookmarkSubscribe
Choose Language Hide Translation Bar
AT
AT
Community Trekker

Pivot Table

Hi,

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

 

I appreciate your help. Thanks

 

 

 

 

0 Kudos
2 ACCEPTED SOLUTIONS

Accepted Solutions
stan_koprowski
Community Manager Community Manager

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

 

0 Kudos
AT
AT
Community Trekker

Re: Pivot Table

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

0 Kudos
2 REPLIES 2
stan_koprowski
Community Manager Community Manager

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

 

0 Kudos
AT
AT
Community Trekker

Re: Pivot Table

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

0 Kudos