Solved: Re: How do I stack columns using a numerical range of columns in a script?

Lavik17 · Jun 9, 2023 9:59 AM

I know this is probably an easy one, but I've been struggling with this for the past 3 hours...

Using JSL, how do I stack columns using a numerical range? for example stack columns 3 to 16.

Thank you!!

Jasean · May 18, 2022 04:46 PM

You can use a matrix to specify the columns in the stack command. Here is an example using a sample table:

dt = Open("$SAMPLE_DATA/Semiconductor Capability.jmp");

StackDT = dt << Stack(
	columns( 5::10 ),
	Source Label Column( "Label" ),
	Stacked Data Column( "Data" ),
	Drop All Other Columns( 1 )
);

View solution in original post

Jasean · May 18, 2022 04:46 PM

You can use a matrix to specify the columns in the stack command. Here is an example using a sample table:

dt = Open("$SAMPLE_DATA/Semiconductor Capability.jmp");

StackDT = dt << Stack(
	columns( 5::10 ),
	Source Label Column( "Label" ),
	Stacked Data Column( "Data" ),
	Drop All Other Columns( 1 )
);

Lavik17 · May 18, 2022 05:12 PM

Thanks @Jasean !!!