cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
AT
AT
Level V

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 Community Manager

Re: Pivot Table

Hi @AT ,

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

And the resulting JSL script--

 

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

cheers,

Stan

 

View solution in original post

AT
AT
Level V

Re: Pivot Table

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

View solution in original post

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-->SplitTables-->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
AT
Level V

Re: Pivot Table

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

Recommended Articles