Aug 6, 2013
I will be needing your support on how to achieve my target table output.
I have a sample data table. I made a Mean Summary for Group 1 and Group 2 Columns, separately.
But i want to combine the two Mean Summary table into 1 table.
However, since Group 1 and Group 2 has different Column Name
During Concatenate this 2 Columns will have separate Columns.
In order to have them in same Column Header i need to Rename it Column into one same Column.
However, i cannot change it manually or in script.
Please help. By the way im using JMP 8.
Thank you in advance.
Jun 29, 2011
Try removing the lock on the column first:
dt=current data table();
dt1=dt<<summary(Group(:Group 1), mean(:data 1, :data 2));
dt2=dt<<summary(Group(:Group 2), mean(:data 1, :data 2));
dt1:Group 1<<set lock(0);
dt1:Group 1<<set name ("Group");
dt2:Group 2<<set lock(0);
dt2:Group 2<<set name ("Group");
close(dt1, no save);
close(dt2, no save);