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
jmpbeginner
Level III

how to rename summary table column (not column# dependent)

I am creating a summary table and need to rename the columns. example:

Summary(

  Group( :RECIPE_FW ),

  Mean ( :MTBW),

  N( :MTBW ),

  output table name("testOutput")

  );

I found that I can reference the column # to rename:

MTBW = Column(3);

MTBW << Set Name ("MTBW (w/Outliers)");

nMTBW = Column(4);

nMTBW << Set Name ("nMTBW");

My concern with this approach is that if more columns are added/inserted, these column(#) references will then rename the wrong column.  Is there a way to rename these columns within the Summary( ) portion? I tried the following and could not get it to work:

Summary(

  Group( :RECIPE_FW ),

  Mean ( :MTBW)<< Set Name ("MTBW (w/Outliers)"),

  N( :MTBW )<< Set Name ("nMTBW"),

  output table name("testOutput")

  );

any help is greatly appreciated! thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
pmroz
Super User

Re: how to rename summary table column (not column# dependent)

dt = data table("testOutput");

column(dt, "Mean(MTBW)") << set name("MTBW (w/Outliers)");

column(dt, "N(MTBW)") << set name("nMTBW");

View solution in original post

2 REPLIES 2
pmroz
Super User

Re: how to rename summary table column (not column# dependent)

dt = data table("testOutput");

column(dt, "Mean(MTBW)") << set name("MTBW (w/Outliers)");

column(dt, "N(MTBW)") << set name("nMTBW");

jmpbeginner
Level III

Re: how to rename summary table column (not column# dependent)

thank you!!