cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
TDF
TDF
Level II

In scripting can I use the column grouping in an analysis?

I have written a script to group columns 3 to 52 in my data table and name the group First 50 bins.

dt = current data table();
// Group columns 3 to 52 (bins 1 to 50)
FirstBin = column name(3);  //column “Bin 0212” in this case, but different for each new data set
ata Table( dt ) << Group Columns( " First 50 bins ", FirstBin, 50);

Saving the script from an analysis I get a list of the column names (even if the group name was selected in the dialogue box)

Discriminant(
	X( :Class for LDA ),
	Y(
		:Bin 0212, :Bin 0205, :Bin 0207,

Is it possible to use the group name instead of the column names?  If not, please can someone suggest an alternative approach.  Ideally, I would rather not create a new table as I want my users to have a single data template, load their new data and then analyze by running two or three prepared scripts.

1 REPLY 1
jthi
Super User

Re: In scripting can I use the column grouping in an analysis?

I think this post could help you jsl: how to plot using a list of groups? as it is fairly similar. Using column groups to run oneway analysis

-Jarmo