cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
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!!