Subscribe Bookmark RSS Feed

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

jmpbeginner

Community Trekker

Joined:

Sep 11, 2013

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
Solution

dt = data table("testOutput");

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

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

2 REPLIES
Solution

dt = data table("testOutput");

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

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

jmpbeginner

Community Trekker

Joined:

Sep 11, 2013

thank you!!