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 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)