cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit. Register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
ACraig
Level I

Can you create a Stacked Data Table with only the selected rows

I have tried it a couple of different ways but none of them seem to work. I am trying to find a way using JSL to create a stacked data table but only with the rows I have selected. I am using the JSL inside of a Workflow.

Data Table( "My Table" ) << Clear Select << 
Select Where( :Name("5 Million") == "Over 5 Million" ) <<
Stack(
	columns(
		:"Baseline Percent Change"n,
		:"District Percent Change"n,
		:"Engineers Percent Change"n
	),
	Source Label Column( "Estimate" ),
	Stacked Data Column( "Percent Change" ),
	Drop All Other Columns( 1 ),
	Output Table(
		"Stack of Fiscal Year 2024 Percent Changes - Over 5 Million)"
	),
	selected rows only(1)
)

Any help is greatly appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Byron_JMP
Staff

Re: Can you create a Stacked Data Table with only the selected rows

Might have to select, then subset, then stack with the subset.

If you're working with a really large table, use the private or invisible arguments to keep the memory overhead down, but remember to close private tables.

JMP Systems Engineer, Health and Life Sciences (Pharma)

View solution in original post

1 REPLY 1
Byron_JMP
Staff

Re: Can you create a Stacked Data Table with only the selected rows

Might have to select, then subset, then stack with the subset.

If you're working with a really large table, use the private or invisible arguments to keep the memory overhead down, but remember to close private tables.

JMP Systems Engineer, Health and Life Sciences (Pharma)