cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
PhamBao
Level IV

How to rename column of summary table?

Hi all,

I have one summary table and I would like to rename one or two columns of the summary table

 

My script is like below:

ST_NEW = dt << Summary(
	Group( :prodgroup3, :link_id, :complevel_1, :test_or_bond_head_id, :bondstage ),
	Mean( :align_ratio_2 ) << Name( "align " ),
	Std Dev( :align_ratio_2 ),
	Output Table Name( "ST_NEW" ), 

);

I would like to rename circled columns to new names

PhamBao_0-1649494389982.png

Could anyone help me to solve this?

Sincerely,


 

3 REPLIES 3
txnelson
Super User

Re: How to rename column of summary table?

there are 2 issue.

  1. By default, the summary daata table produced is Linked to the original table, which forces the table to be locked.  This defaule needs to be over ruled.
  2. The renaming of the column needs to be done after the new table is produced.
Names Default To Here( 1 );
// Open Data Table: big class.jmp
// → Data Table( "big class" )
dt = Open( "$SAMPLE_DATA/big class.jmp" );
ST_NEW = dt << Summary(
	Group( :sex ),
	Mean( :height ),
	Std Dev( :height ),
	Output Table Name( "ST_NEW" ),
	link to original data table( 0 )
);
ST_NEW:"Mean(height)"n << set name( "align" );
Jim
ih
Super User (Alumni) ih
Super User (Alumni)

Re: How to rename column of summary table?

If being linked to the original table is important (you want to select a row in the summary and have relevant rows in the original table be selected, for example) you could make a new column with the name you are looking for and then hide the original:

Names default to here(1);
dt = Open( "$SAMPLE_DATA/big class.jmp" );
ST_NEW = dt << Summary(
	Group( :sex ),
	Mean( :height ),
	Std Dev( :height ),
	Output Table Name( "ST_NEW" )
);
ST_NEW << New Column("align", Numeric, "Continuous", Format("Best", 12), Formula(:"Mean(height)"n));
ST_NEW:"Mean(height)"n << Hide( 1 );

Re: How to rename column of summary table?

you can also rename those stat columns with the drop down in below menu ...

Mandy_Chambers_0-1649770220689.png

 

Recommended Articles