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
HansD
Level I

Change Label for Missing in Tabluate

I'm using Tabulate with the 'include missing for grouping column' - I would like to change the label for the word Missing in the table

4 REPLIES 4
Thierry_S
Super User

Re: Change Label for Missing in Tabluate

Hi,
A quick workaround would be to save the Tabulate output as a table (Main Platform Menu: Red Triangle Top Left > Make Into a Table) and change the column header there. However, if you need to work with the output itself, you will need to look deep into the Tree Structure of the output to figure out if the Column labels can me edited (from a quick check, it does not seem to be editable but I'll leave other to comment)
Best,
TS
Thierry R. Sornasse
HansD
Level I

Re: Change Label for Missing in Tabluate

Hi Thierry,

 

Thanks for your response - your solution will give an solution.  I would not like to take this route for this specific application

Hans

txnelson
Super User

Re: Change Label for Missing in Tabluate

The work around that I would do, is to replace the missing cells with the value you want to be displayed, thus changing the missing value to a specified value.

 

for each row(
     If(:sex ==  "", :sex = "my new group" 
);
Jim
HansD
Level I

Re: Change Label for Missing in Tabluate

Hi Jim,

Most probably the easiest solution - I hoped there was a feature in JMP I didn't see.

Thanks for your response

Hans