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.
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);