Deleting rows in JSL

PS — Wed, 04 Apr 2018 14:28:14 GMT

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

Re: Deleting rows in JSL

pmroz — Wed, 04 Apr 2018 14:39:31 GMT

Add the word AS before column:

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

topic Re: Deleting rows in JSL in Discussions

Deleting rows in JSL

Re: Deleting rows in JSL