cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
PS
PS
Level III

Deleting rows in JSL

Hi,

this is a very basic question that has been answered many times, but I can't get it to work.


//Define the column name here first Col = "mycolumn.xyz"; dt = current data table (); //Create new table dt2, copy first table dt, sort it by two different columns dt2 = Data Table( dt ) << Sort( By( :WAFER, Column(dt, Col) ), Order( Ascending, Ascending ) ); ColValues = {}; ColValues = Column(dt2, Col) << Get Values; //And this is where it fails. //Not working: dt2 << select where (Column(dt2, Col) < 1); dt2 << delete rows; //This here is working: dt2 << select where (:mycolumn.xyz < 1); dt2 << delete rows;

 I have tried different methods of Eval(Substitute(Expr(),Expr(),Parse())) but without result.

 

Thanks for your help 

1 ACCEPTED SOLUTION

Accepted Solutions
pmroz
Super User

Re: Deleting rows in JSL

Add the word AS before column:

dt2 << select where (as Column(dt2, Col) < 1);

View solution in original post

1 REPLY 1
pmroz
Super User

Re: Deleting rows in JSL

Add the word AS before column:

dt2 << select where (as Column(dt2, Col) < 1);