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.
Choose Language Hide Translation Bar
View Original Published Thread

How to rename column of summary table?

PhamBao
Level II

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