cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
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)