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.
Get the free JMP Student Edition for qualified students and instructors at degree granting institutions.
Choose Language Hide Translation Bar
View Original Published Thread

Column Group with variable Column Count

Phil_Nash
Level II
Query_DT << GROUP COLUMNS("WEEKS",COLUMN(12),75);
COLGRP = Query_DT << GET COLUMN GROUP ("WEEKS");

Query_Stack = Query_DT << STACK(columns(COLGRP),
	Source Label Column( "Label" ),
	Stacked Data Column( "Data" )
);

I need to group columns to create a stacked table..  the problem is that the number of columns can vary.  This code works fine, except in the Group Columns function I need the 75 to be a variable count of columns from that same starting position.

 

I can't seem to find exactly what I'm looking for in either the Scripting Library or the search here.  Any ideas?

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User


Re: Column Group with variable Column Count

What is the number 75 based on?

 

Script below will group columns starting from start_idx column to the last column

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
start_idx = 4;
dt << Group Columns(Column(start_idx), N Cols(dt) - start_idx + 1);
-Jarmo

View solution in original post

2 REPLIES 2
jthi
Super User


Re: Column Group with variable Column Count

What is the number 75 based on?

 

Script below will group columns starting from start_idx column to the last column

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
start_idx = 4;
dt << Group Columns(Column(start_idx), N Cols(dt) - start_idx + 1);
-Jarmo
Phil_Nash
Level II


Re: Column Group with variable Column Count

75 is the number of columns to include in the group.  Your code worked perfectly.  Thank you!