cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar

JMP 15 not compatible with JMP14 JSL

In JMP14, i am using code

 

 

r = dt << Get Rows Where( name("sex") == "M" );

 

But it does not work in JMP15.

I cannot change code at this point as it is used many places in the code.

have seen previously also with newer releases previous JMP JSL is not compatible, face the issue again.

 

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
r = dt << Get Rows Where( :sex == "M" );
Show( r );
6 REPLIES 6
Jeff_Perkinson
Community Manager Community Manager

Re: JMP 15 not compatible with JMP14 JSL

I've just tested your code:

 

 

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
r = dt << Get Rows Where( :sex == "M" );
Show( r );

 

and I get the same results in JMP 14 and JMP 15.

 

Here's the log from JMP 14:

 

 

/*:
//:*/
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
r = dt << Get Rows Where( :sex == "M" );
Show( r );
/*:

r = [6, 7, 8, 12, 13, 14, 15, 21, 22, 23, 24, 25, 26, 27, 30, 31, 32, 33, 34, 37, 39, 40];

and from JMP 15:

 

/*:
//:*/
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
r = dt << Get Rows Where( :sex == "M" );
Show( r );
/*:

r = [6, 7, 8, 12, 13, 14, 15, 21, 22, 23, 24, 25, 26, 27, 30, 31, 32, 33, 34, 37, 39, 40];

Can you give us some detail about what is failing for you? Is there an error message?

-Jeff

Re: JMP 15 not compatible with JMP14 JSL

you need to test this: r = dt << Get Rows Where( name("sex") == "M" );
i tested again and got error again as below

Name Unresolved: sex{1} in access or evaluation of 'sex' , sex/*###*/

at line 3 in Scripting Index

Re: JMP 15 not compatible with JMP14 JSL

Whole code as below

 

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
r = dt << Get Rows Where( name("sex") == "M" );
Show( r );
Jeff_Perkinson
Community Manager Community Manager

Re: JMP 15 not compatible with JMP14 JSL

My apologies. I missed the difference between the two code snippets in your original post.

 

However, I tested your code as posted immediately above in JMP 14 and JMP 15 and got the same result in both.

 

Log from JMP 14:

 

//:*/
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
r = dt << Get Rows Where( name("sex") == "M" );
Show( r );
/*:

Name Unresolved: sex{1} in access or evaluation of 'sex' , sex/*###*/

In the following script, error marked by /*###*/
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
r = dt << Get Rows Where( sex/*###*/ == "M" );
Show( r );

Log from JMP 15:

/*:
//:*/
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
r = dt << Get Rows Where( name("sex") == "M" );
Show( r );
/*:

Name Unresolved: sex{1} in access or evaluation of 'sex' , sex/*###*/

at line 3 in untitled script 4.jsl
-Jeff
jimloughlin
Level III

Re: JMP 15 not compatible with JMP14 JSL

For what it is worth, I get the same results in v13.2.1.  

 

 

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
r = dt << Get Rows Where( name("sex") == "M" );
Show( r );
/*:
Name Unresolved: sex{1} in access or evaluation of 'sex' , sex/*###*/
In the following script, error marked by /*###*/
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
r = dt << Get Rows Where( sex/*###*/ == "M" );
Show( r );

 

Jim Loughlin
Loughlin Consulting

Re: JMP 15 not compatible with JMP14 JSL

You should employ the : scoping operator to the Name( "sex" ) directive if you want to use it as a column name. This form works:

 

r = dt << Get Rows Where( :Name( "sex" ) == "M" );