JMP JSL Stack operation does not allow citing predefined variable?

wencun6

I was writing a script to stack bunch of columns togthers using JSL script like below. However, I am keeps getting error message that "Number of series should be a positive integer". I need the N to be variable depending on how many columns need to be stacked for different tables. I have other script to identify the number of column which works perfectly fine. Just the stack function somehow does not work.

 

 

dt_join2=current data table();
N=49
Data Table( dt_join2 ) << Stack(
columns(Lstcols ),
Source Label Column( lstCols3 ),
Stacked Data Column( lstCols2 ),
Number of Series(N)
);

 

txnelson

You can dynamically code the Stack Platform.  Below is a simple example:

Names Default to Here(1);
dt=open("$SAMPLE_DATA/Semiconductor Capability.jmp");

Listcols={:NPN1, :PNP1, :PNP2, :NPN2};
lstCos3="Discriptors";
lstCos2="Values";
n=2;

Data Table( "semiconductor capability" ) << Stack(
	columns( Listcols ),
	Source Label Column( lstCos3 ),
	Stacked Data Column( lstCos2 ),
	Drop All Other Columns( 1 ),
	Number of Series( eval(N) )
);

However, what I am picking up from your discussion is that you are thinking that Source Label Column, and Stacked Data Column, can be a list of names.  The documentation below shows, that only a single name can be provided

Stacked Data Column

Assigns a name to the column that will contain the data for the stacked columns. The default name is Data. Leave the box empty if you do not want this column to appear in the new table.

Source Label Column

Assigns a name to the column that will contain the original table’s column names. The default name is Label. Leave the box empty if you do not want this column to appear in the new table.

 

If you need to have specific names for the Data and Label columns produced in the Stack Platform, you can simply change the names in the new table that is produced.