topic Re: JSL: Group columns in Discussions

JSL: How do I Group Columns with JSL?

Tue, 26 Sep 2017 14:35:54 GMT

Hello community:

One can group columns by selecting them in the columns window and choosing "Group columns" in the context menu. Is there a JSL statement doing the same thing? I found nothing in the operators index or scripting guide.

Thanks,
Dahla

Re: JSL: Group columns

mpb — Fri, 02 Oct 2009 19:37:46 GMT

Here's an example of how to do Group Columns in a script.

dt = current data table();
//Following Expects Fitness Table to be Current;
column("RunPulse") << Set Selected(1);
column("RstPulse") << Set Selected(1);
column("MaxPulse") << Set Selected(1);

dt << group columns();

Michael

Re: JSL: Group columns

Sun, 04 Oct 2009 17:40:10 GMT

Thanks for the solution, Michael!

One additional question: How do you know the "group columns()" statement? I wonder if one can find a complete overview of jsl statements somewhere?

Dahla

Re: JSL: Group columns

mpb — Sun, 04 Oct 2009 22:39:13 GMT

I guessed. The JSL messages corresponding to menu items tend to be the same as the equivalent menu item text. The JMP Scripting Guide (Help>Books>JMP Scripting Guide) contains a pretty complete list of JSL statements and basic usage. I think "group columns" just was overlooked when the most current edition was made. I suppose there is an outside possibility that it was undocumented because it's not thoroughly tested. If you are worried about that possibility you may want to query JMP support to verify it's safe to use (in JSL) in the current 8.0.1 version.

Michael

Re: JSL: Group columns

Mon, 05 Oct 2009 10:05:44 GMT

Thanks again, although this is not the answer I hoped for. ;)
Do you have another guess for the right command to set the title of a column group?

Dahla

Re: JSL: Group columns

mpb — Tue, 06 Oct 2009 11:34:28 GMT

dt << group columns("Pulses")

Re: JSL: Group columns

chungwei — Wed, 07 Oct 2009 17:16:36 GMT

This statement

data table("Fitness") << group columns("test", :Runtime, 4);

will put 4 columns, starting with Runtime, into a group, and name the group "test".

Alternatively,

data table("Fitness") << group columns("AAA", :Runtime :: :MaxPulse);

will group Runtime thru MaxPulse and name the group "AAA"

Re: JSL: Group columns

mpb — Wed, 07 Oct 2009 18:33:40 GMT

Thanks for a more complete illustration of the "group columns" syntax. Do you know if there is an extension of it that allows grouping non contiguous columns, e.g. in the Fitness table just RunPulse and MaxPulse? If that cannot be done directly then the Selects followed by the simpler group columns does permit it which is the only advantage to it I can see. The syntax you illustrate is more compact and direct.

Michael

Re: JSL: Group columns

Thu, 08 Oct 2009 07:42:07 GMT

Thanks, ChungWei!

This statement helps making my code shorter.

Dahla

Message was edited by: Dahla

Re: JSL: Group columns

chungwei — Thu, 08 Oct 2009 13:10:55 GMT

I think this will do it

datatable("Fitness 3D") << group columns("test", {:RunPulse, :MaxPulse});

Re: JSL: Group columns

mpb — Thu, 08 Oct 2009 15:01:46 GMT

Ah, a *List* of column names...It surely does work! Thanks ChungWei.

Re: JSL: Group columns

Jon_Weisz — Fri, 09 Oct 2009 17:50:54 GMT

Hello, I am a SAS employee and thought I would help with the questions of "How do you know the "group columns()" statement?". I can think of two good ways to find the JSL command to group columns or perform other actions.
1. Look under help->Books->JSL Scripting Guide, then in the pdf file search for Group Columns.
2. If you look in JMP under the help->Indexes->Object Scripting menu, you can then select Data Table Cols. This will then show all the messages that the column object can take. Group Columns is one of the messages shown.

Re: JSL: Group columns

mpb — Fri, 09 Oct 2009 20:10:35 GMT

Thanks for these excellent tips. In this case though, my 8.0.1 JSL Scripting Guide pdf docs show nothing for "Group Columns". The Object Scripting Guide does list Group Columns as a message to be sent but does not elaborate on the syntax needed to make it work. Are you using a later version?

Re: JSL: Group columns

Sun, 11 Oct 2009 08:24:17 GMT

Searching the Scripting Guide is the first thing I normally do if I look for a JSL statement. If "Group Columns" was explained there, this topic wouldn't exist. As for the Object Scripting Index, I have the same question as mpb concerning the syntax.

Thanks for your help,
Dahla

Re: JSL: Group columns

mpb — Mon, 12 Oct 2009 13:48:10 GMT

I did submit an item to JMP support regarding the lack of documentation for Group Columns. According to their reply, this is intended be remedied in the 8.0.2 release.