I've also experienced this and have found one workaround. Save the Open() command as a separate script and use Include() to run the code.   // Create a jsl file with the Open() command f = Save Text File( "~/Desktop/test.jsl", Char( Name Expr( Open( "~/Desktop/test.xlsx", Worksheets( "Data" ), Use for all sheets( 1 ), Concatenate Worksheets( 0 ), Create Concatenation Column( 0 ), Worksheet Settings( 1, Has Column Headers( 1 ), Number of Rows in Headers( 1 ), Headers Start on Row( 1 ), Data Starts on Row( 2 ), Data Starts on Column( 1 ), Data Ends on Row( 0 ), Data Ends on Column( 0 ), Replicated Spanned Rows( 1 ), Replicated Spanned Headers( 0 ), Suppress Hidden Rows( 1 ), Suppress Hidden Columns( 1 ), Suppress Empty Columns( 1 ), Treat as Hierarchy( 0 ), Multiple Series Stack( 0 ), Import Cell Colors( 0 ), Limit Column Detect( 0 ), Column Separator String( "-" ) ) ) ) ) ); // Invoke Open() via user input nw = New Window( "open test", Button Box( "OK", Include( f ) ) ); ... View more

This works too: a = 2; // Concat scalar with empty matrix b = a || []; // Same, but in place a ||= []; Show(a, b); /*: a = [2]; b = [2];     ... View more

Loops are usually used for iterating through table rows or over items in a list, hence an increment by one is most common. However, the third argument must not be i++. It could be anything that makes sense.   A few examples: For(i = 1, i <= 10, i = i + 0.1, Expr()); // Increment < 1 (100 iterations) For(i = 10, i > 1, i--, Expr()); // Loop "backwards" For(x = 2, x <= 10, x = 2, Expr()); // Eternal loop (better avoid these)   ... View more

It does not work because the loop is placed inside the New Column definition. Either create the column and fill its values in separate statements, or use a column formula.   Look at these three jsl examples that should give identical result: Names Default To Here(1); dt = Current Data Table(); tr = N Rows(dt); //1. Fill values with a For() loop dt << New Column("TEST", "CHARACTER"); For(i = 1, i <= tr, i++, :TEST[i] = If(:TIME[i] == "BASELINE" & :VALUE[i] > 3, "YES", "NO" ) ); //2. Fill with For Each Row() dt << New Column("TEST2", "CHARACTER"); For Each Row(:TEST2 = If(:TIME == "BASELINE" & :VALUE > 3, "YES", "NO")); //3. Use a column formula in TEST3 dt << New Column("TEST3", "CHARACTER", Formula(If(:TIME == "BASELINE" & :VALUE > 3, "YES", "NO")) );     ... View more

An alternative to using two columns to arrive at the counts would be to count the rows of each combination with the ColNumber() function.   For example: Col Number(Row(), :J1, :SOG, :BUCKET);       ... View more

Try the By() role to get all predicteds in the same column. Iteration over a list is then not necessary and the generated prediction formula will automatically apply conditional statements to separate the different values of the by-column. The main difference is that all plots will share the same window.    DataCV = Open("C:\Desktop\JMP\sample_data.csv"); DataCV << biv = Bivariate( Y(:c_mm_deembed_pf), X(:v_dut_volt), By(:process), Where(:c_type == "Cdg"), Fit Spline(0.1, Standardized, {Save Predicteds}) ); ... View more