topic JSL Test for Formula Column Evaluations Done in Discussions

JSL Test for Formula Column Evaluations Done

terapin — Mon, 17 Dec 2018 16:39:18 GMT

I'm using JSL to import some data from csv files and to create some new formula columns. Before proceeding with additional steps, I want to test for whether the new formula columns have completed their evaluations. Currently, I use the Wait() command but that seems like an unelegant and inefficient way to complete the evaluation.

I've looked in the help manual but can't find a JSL command that allows me to test for whether the Evaluations in my new formula columns have been completed. Does anyone either know of a command or a method that allows the JSL to wait only as long as is necessary for the formulas to be evaluated before proceeding. Thanks in advance.

Re: JSL Test for Formula Column Evaluations Done

ian_jmp — Mon, 17 Dec 2018 16:49:52 GMT

Try something like (from 'Help > Scripting Index'):

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Central Limit Theorem.jmp" );
dt << Add Rows( 100 );
dt << Rerun Formulas;

Re: JSL Test for Formula Column Evaluations Done

terapin — Mon, 17 Dec 2018 17:13:55 GMT

Thanks Ian,

That was very easy!

Re: JSL Test for Formula Column Evaluations Done

txnelson — Mon, 17 Dec 2018 17:31:38 GMT

dt << run formulas;