cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-559877%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%88%97%E6%95%B0%E3%81%8C%E5%8F%AF%E5%A4%89%E3%81%AE%E5%88%97%E3%82%B0%E3%83%AB%E3%83%BC%E3%83%97%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-559877%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EQuery_DT%20%26lt%3B%26lt%3B%20GROUP%20COLUMNS(%22WEEKS%22%2CCOLUMN(12)%2C%3CSTRONG%3E75%3C%2FSTRONG%3E)%3B%0ACOLGRP%20%3D%20Query_DT%20%26lt%3B%26lt%3B%20GET%20COLUMN%20GROUP%20(%22WEEKS%22)%3B%0A%0AQuery_Stack%20%3D%20Query_DT%20%26lt%3B%26lt%3B%20STACK(columns(COLGRP)%2C%0A%20Source%20Label%20Column(%20%22Label%22%20)%2C%0A%20Stacked%20Data%20Column(%20%22Data%22%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%E7%A9%8D%E3%81%BF%E4%B8%8A%E3%81%92%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%82%92%E4%BD%9C%E6%88%90%E3%81%99%E3%82%8B%E3%81%AB%E3%81%AF%E3%80%81%E5%88%97%E3%82%92%E3%82%B0%E3%83%AB%E3%83%BC%E3%83%97%E5%8C%96%E3%81%99%E3%82%8B%E5%BF%85%E8%A6%81%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%E5%95%8F%E9%A1%8C%E3%81%AF%E3%80%81%E5%88%97%E3%81%AE%E6%95%B0%E3%81%8C%E7%95%B0%E3%81%AA%E3%82%8B%E5%8F%AF%E8%83%BD%E6%80%A7%E3%81%8C%E3%81%82%E3%82%8B%E3%81%93%E3%81%A8%E3%81%A7%E3%81%99%E3%80%82%E3%81%93%E3%81%AE%E3%82%B3%E3%83%BC%E3%83%89%E3%81%AF%E5%95%8F%E9%A1%8C%E3%81%AA%E3%81%8F%E5%8B%95%E4%BD%9C%E3%81%97%E3%81%BE%E3%81%99%E3%81%8C%E3%80%81Group%20Columns%20%E9%96%A2%E6%95%B0%E3%81%A7%E3%81%AF%E3%80%8175%20%E3%82%92%E5%90%8C%E3%81%98%E9%96%8B%E5%A7%8B%E4%BD%8D%E7%BD%AE%E3%81%8B%E3%82%89%E3%81%AE%E5%88%97%E3%81%AE%E5%A4%89%E6%95%B0%E3%82%AB%E3%82%A6%E3%83%B3%E3%83%88%E3%81%AB%E3%81%99%E3%82%8B%E5%BF%85%E8%A6%81%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EScripting%20Library%20%E3%81%A7%E3%82%82%E3%81%93%E3%81%93%E3%81%AE%E6%A4%9C%E7%B4%A2%E3%81%A7%E3%82%82%E3%80%81%E6%8E%A2%E3%81%97%E3%81%A6%E3%81%84%E3%82%8B%E3%82%82%E3%81%AE%E3%81%8C%E6%AD%A3%E7%A2%BA%E3%81%AB%E8%A6%8B%E3%81%A4%E3%81%8B%E3%82%89%E3%81%AA%E3%81%84%E3%82%88%E3%81%86%E3%81%A7%E3%81%99%E3%80%82%E4%BD%95%E3%81%8B%E6%A1%88%E3%81%AF%EF%BC%9F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-559877%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%86%E3%82%A3%E3%83%B3%E3%82%B0%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-559886%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E5%88%97%E6%95%B0%E3%81%8C%E5%8F%AF%E5%A4%89%E3%81%AE%E5%88%97%E3%82%B0%E3%83%AB%E3%83%BC%E3%83%97%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-559886%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E75%E3%81%A8%E3%81%84%E3%81%86%E6%95%B0%E5%AD%97%E3%81%AF%E4%BD%95%E3%81%AB%E5%9F%BA%E3%81%A5%E3%81%84%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%E3%81%8B%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%E4%BB%A5%E4%B8%8B%E3%81%AE%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%81%AF%E3%80%81start_idx%20%E5%88%97%E3%81%8B%E3%82%89%E6%9C%80%E5%BE%8C%E3%81%AE%E5%88%97%E3%81%BE%E3%81%A7%E5%88%97%E3%82%92%E3%82%B0%E3%83%AB%E3%83%BC%E3%83%97%E5%8C%96%E3%81%97%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(1)%3B%0Adt%20%3D%20Open(%22%24SAMPLE_DATA%2FBig%20Class.jmp%22)%3B%0Astart_idx%20%3D%204%3B%0Adt%20%26lt%3B%26lt%3B%20Group%20Columns(Column(start_idx)%2C%20N%20Cols(dt)%20-%20start_idx%20%2B%201)%3B%0A%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-559909%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E5%88%97%E6%95%B0%E3%81%8C%E5%8F%AF%E5%A4%89%E3%81%AE%E5%88%97%E3%82%B0%E3%83%AB%E3%83%BC%E3%83%97%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-559909%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E75%20%E3%81%AF%E3%80%81%E3%82%B0%E3%83%AB%E3%83%BC%E3%83%97%E3%81%AB%E5%90%AB%E3%82%81%E3%82%8B%E5%88%97%E3%81%AE%E6%95%B0%E3%81%A7%E3%81%99%E3%80%82%E3%81%82%E3%81%AA%E3%81%9F%E3%81%AE%E3%82%B3%E3%83%BC%E3%83%89%E3%81%AF%E5%AE%8C%E7%92%A7%E3%81%AB%E6%A9%9F%E8%83%BD%E3%81%97%E3%81%BE%E3%81%97%E3%81%9F%E3%80%82%E3%81%82%E3%82%8A%E3%81%8C%E3%81%A8%E3%81%86%E3%81%94%E3%81%96%E3%81%84%E3%81%BE%E3%81%97%E3%81%9F%EF%BC%81%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
Phil_Nash
Level II

Column Group with variable Column Count

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!

Recommended Articles