topic Re: Scripting/Row State Columns in Discussions

Scripting/Row State Columns

Steven_Moore — Thu, 04 Feb 2016 21:37:37 GMT

I have a data table with several Row State columns. I also have several scripts saved to the data table for analysis. Each script requires its own Row States, so I have to remember which Row State column goes with which script and then copy to Row States from the columns. Is there a way to edit my scripts to set the correct row states before the analysis is done? Thanks for any help!

Re: Scripting/Row State Columns

txnelson — Thu, 04 Feb 2016 21:45:59 GMT

All you need to do, is to add to the top of your script the jsl to copy the rowstate column to the rowstates before your do the analysis. Assuming the rowstate column is called RowState_1, all that you have to do is to have the following at the beginning of your script:

Names Default to Here( 1 );

dt=current data table();

dt:RowState_1 << Copy to Row States();

Re: Scripting/Row State Columns

Steven_Moore — Fri, 05 Feb 2016 12:20:40 GMT

Jim,

Here is the script I am trying to run with the three lines added that you suggest.. My Row State column is "Break - Cause Not Known". Now this script will not run. What am I missing?

THANKS!!!

Names Default to Here( 1 )

dt=current data table();

dt:Break - Cause Not Known << Copy to Row States();

Graph Builder(Size( 661, 500 ),Variables( X( :Downtime Category ), Y( :Total Minutes Down ), Overlay( :Crew ) ),Elements(Bar(X,Y,Legend( 7 ),Summary Statistic( "N" ),Label( "Label by Value" ))),SendToReport(Dispatch({},"graph title",TextEditBox,{Set Text("Line 180: Number Of Stops By Category By Crew - January 2016)}),Dispatch( {}, "X title", TextEditBox, {Set Text( "" )} ),Dispatch( {}, "Y title", TextEditBox, {Set Text( "Number Of Stops" )} )))

Re: Scripting/Row State Columns

txnelson — Fri, 05 Feb 2016 12:27:38 GMT

The column "Break - Cause Not Known" is being parsed by JMP as being an assignment statement. This is because of the "-" in the name. Change the statement to:

dt:Name("Break - Cause Not Known")<<Copy to Row States();

Re: Scripting/Row State Columns

Steven_Moore — Fri, 05 Feb 2016 12:28:35 GMT

Got it! The name of the Row State column has to be in quotes! Works great! Thanks!!!!!! The JSL is all Greek to me - I am an old Fortran/Basic guy and my brain does not seem to be wired for JSL....YET.

Re: Scripting/Row State Columns

txnelson — Fri, 05 Feb 2016 12:39:17 GMT

My background started much the same as yours. JSL is a powerful language that one keeps learning more and more about it.

P.S.

Please click on the "Correct Answer" button to mark this discussion as Answered to help the responders quickly identify it as having been responded to.

Thanks