15697_en-US

liliconcom

JMP scripting<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

I would like to script the conversion of results from a formula in a column to static numbers. Is that possible?

Re: JMP scriptingSimple removal formula problem, I always find the master code to solve.thank youRe: JMP scripting

Point taken. In this case is the house brand version of a script. It will never be shared or used by the outside world.

Re: JMP scripting

Your simplification should work great as long as JMP properly points to the correct data table.  I suggest that you scope the variable to ensure that there is no question as to what data table you are working with.

dt:Values From Formula << deleteFormula;

It is a good coding practice to remove the ambiguities.

Re: JMP scripting

Thanks for pointing me in the right direction. I simplified your approach to

:Values From Formula << deleteFormula;

which worked like a charm.

As usual, the correct answer will come when the question is phrased correctly.

Re: JMP scripting

If I understand correctly, you just have to delete the formula that generated the values (via the 'Column Info' dialog).

In JSL:

NamesDefaultToHere(1);

dt = NewTable("Test Remove Formula",

NewColumn("Values From Formula",Numeric, Continuous, Formula(RandomNormal())),

AddRows(10)

);

Wait(3);

Column(dt, "Values From Formula") << deleteFormula;