Deleting rows in JSL

[#1]

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 

[#2 · Accepted solution]

Add the word AS before column:

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