Stack a group of columns

axcelenator1

Hello, I have some table with a group of columns. I want to stack the group with a script how can I do that?

dt = open("C:\Users\My.jmp");

s_list = {h1, j2, k3};//List


//Generate XX new columns by Text to Cols ADD-In
For( i = 1, i<= Length(s_list), i++, 
	    dt << New Column  ("My_New_Coloumn_" || s_list[i],  
		Numeric,
		Continuous,
		Formula(
				Num(Word( i, As Column(Column("CPU" )), "|" ))//CPU is a column that contains for example: 5|5|7
			    ),
		),
		
		
);
dt << Group Columns(:My_New_Column_h1,3);

Here I try to stack the aboved Group

 

jerry_cooper

Hi @axcelenator1,

Does the example below help for what you are trying to do?

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Blood Pressure.jmp" );
group = dt << Group Columns( BP 8M, 9 );

dt << Stack(
	columns(
		dt << Get Column Group( group );
	),
	Source Label Column( "Label" ),
	Stacked Data Column( "Data" )
)