cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
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)