topic Re: JSL fill to end of table using first row value in Discussions

JSL fill to end of table using first row value

ReginaHong — Thu, 21 Mar 2019 10:27:48 GMT

Hi,

Using JSL script, I want the first cell value in "Intercept" column to Fill to end of table with the same value in first cell. Can anyone show me how to write it in script?

Re: JSL fill to end of table using first row value

ian_jmp — Thu, 21 Mar 2019 11:51:11 GMT

Using 'Help > Scripting Index' is good for this kind of thing. In this case, the example is:

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << New Column( "X" );
dt:X << Set Each Value( 5 );

Re: JSL fill to end of table using first row value

andersonmj2 — Thu, 21 Mar 2019 13:39:15 GMT

Ian is correct in his answer to your question. I have at times wanted to do the OTHER thing in the menu image you showed (Fill to row ...), which is also pretty simple by just using the Row Index functions to select the cells you want to fill.

dt << Select Where( Any( Row() == Index( 7, 10 ) ) );

Re: JSL fill to end of table using first row value

ReginaHong — Fri, 22 Mar 2019 01:41:58 GMT

Hi Ian,

What if my value in first row can change from time to time instead of having a fix value? Can I script it in a way that it will always use the first row value (not a fix value) to fill up the rest of the rows in that column?

Re: JSL fill to end of table using first row value

ian_jmp — Fri, 22 Mar 2019 10:38:36 GMT

I think the answer depends on what else is happening within your JSL, and how you want a user (assuming there is one) to interact with this. You can do something like:

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << New Column( "X" );
dt:X[1] = 5;
dt << New Column( "X2", Formula(if(Row() == 1, :X, Lag(:X2, 1))));
dt << runFormulas;
Wait(2);
dt:X[1] = 10;
dt << runFormulas;

but that doesn't seem very useful. Because a formula column is computed, JMP will not allow you to edit one of the cells therein.