topic Turn off "Suppress Eval" on all columns in Discussions

Turn off "Suppress Eval" on all columns

MarkJSchwab — Fri, 14 Jun 2024 20:58:35 GMT

Is there a way to turn off "Suppress Eval" for all columns?

(It seems to have automatically turned on "Suppress Eval" when I saved a .jrp, and I need to evaluate many formula columns in this data table.)

Re: Turn off "Suppress Eval" on all columns

txnelson — Fri, 14 Jun 2024 21:10:00 GMT

See Suppress Formula Eval() in the Scripting Index

Re: Turn off "Suppress Eval" on all columns

hogi — Sat, 15 Jun 2024 07:01:16 GMT

suppress Formula Eval(1) [without a data table] is great to trick colleagues - no chance to notice - JMP is stuck and no chance to fight against it, neither via the GUI:

nor via dt << Suppress Formula Eval( 0 );

_____________________________________

Some Table operations like Join have a setting to suppress formula evaluations:

If every column is disabled individually, then you have to enable the formula evaluation individually:

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

f= Function({},New Column( "height+weight",
	Formula( :height + :weight ),
));
f;
f;
f;
column (6) << Suppress Eval( 1 );
column (7) << Suppress Eval( 1 );
column (8) << Suppress Eval( 1 );

Ncols = ncols(dt);

for (i=1,i<=NCols, i++,
column(i) << suppress  eval(0)
)

fun fact:
the status in the columns menu doesn't get updated automatically, so don't get confused by the gray plus sign:

Re: Turn off "Suppress Eval" on all columns

jthi — Sat, 15 Jun 2024 06:48:23 GMT

There is also difference between << Suppress Formula Eval() and Suppress Eval(). << Suppress Formula Eval() is for data tables and Suppress Eval for formula columns

If you have Suppress Eval enabled, you can loop over your columns (use << get column names and for each) and send << Suppress Eval(0) to all your columns. I'm not sure if there is any "easy" way to do this interactively (Standardize Attributes won't work as it will replace all your formulas), subset can be used but it will create a new table which might not be ideal.

But if you don't mind creating new datatable subset is fairly easy option

Re: Turn off "Suppress Eval" on all columns

LuzBosco — Mon, 15 Jul 2024 13:39:37 GMT

Thanks for answering, you made my day.