Choose Language Hide Translation Bar
PS
PS
Community Trekker

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 

0 Kudos
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);

View solution in original post