395995_en-US

liliconcom

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

ScriptingRe: Change Label for Missing in TabluateHi,
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,
TSRe: 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" 
);