topic Re: Pivot Table in Discussions

Pivot Table

AT — Wed, 30 Jan 2019 19:02:11 GMT

Hi,

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

I appreciate your help. Thanks

stan_koprowski — Wed, 30 Jan 2019 19:11:39 GMT

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

AT — Wed, 30 Jan 2019 22:08:53 GMT

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